Showing posts with label autogrow. Show all posts
Showing posts with label autogrow. Show all posts

Friday, March 23, 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 running 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...
>

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...
>> 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!
>>
>>
>

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...
>