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...
>> Is it possible to find out the last time a database needed to AUTOGROW?
>> Thanks!
>|||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 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...
>> Is it possible to find out the last time a database needed to AUTOGROW?
>> Thanks!
>>
>|||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...
>> 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...
>> Is it possible to find out the last time a database needed to AUTOGROW?
>> Thanks!
>>
>>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment