Wednesday, March 21, 2012

Last time a database needed to AUTOGROW

Is it possible to find out the last time a database needed to AUTOGROW?
Thanks!There is an event in trace for that but if you didn't have it running you
are probably out of luck.
Andrew J. Kelly SQL MVP
"Shaun Beane" <shaun.beane@.gmail.nospam.com> wrote in message
news:u9othlZBGHA.1124@.TK2MSFTNGP10.phx.gbl...
> Is it possible to find out the last time a database needed to AUTOGROW?
> Thanks!
>|||Andrew
Thank you for the input! So I guess I would just have to leave profiler
running all the time to catch it, eh?
Shaun
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:%239UUULaBGHA.1124@.TK2MSFTNGP10.phx.gbl...
> There is an event in trace for that but if you didn't have it running you
> are probably out of luck.
> --
> Andrew J. Kelly SQL MVP
>
> "Shaun Beane" <shaun.beane@.gmail.nospam.com> wrote in message
> news:u9othlZBGHA.1124@.TK2MSFTNGP10.phx.gbl...
>|||If you really need that information, yes. But Profiler comes with a cost. If
you need this, use a
server side trace.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Shaun Beane" <shaun.beane@.gmail.nospam.com> wrote in message
news:eYBCqWaBGHA.952@.TK2MSFTNGP10.phx.gbl...
> Andrew
> Thank you for the input! So I guess I would just have to leave profiler r
unning all the time to
> catch it, eh?
> Shaun
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:%239UUULaBGHA.1124@.TK2MSFTNGP10.phx.gbl...
>|||Ahh, excellent. Thank you!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23lD20aaBGHA.3580@.TK2MSFTNGP11.phx.gbl...
> If you really need that information, yes. But Profiler comes with a cost.
> If you need this, use a server side trace.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Shaun Beane" <shaun.beane@.gmail.nospam.com> wrote in message
> news:eYBCqWaBGHA.952@.TK2MSFTNGP10.phx.gbl...
>

No comments:

Post a Comment