Monitor Autogrow

Is there a way to setup a job to monitor when an autogrow occurs?
AF
SQL Server Profiler?
"AF" <af.at.work@.gmail.com> wrote in message
news:1168521633.974360.119620@.i39g2000hsf.googlegr oups.com...
> Is there a way to setup a job to monitor when an autogrow occurs?
>
|||If you are using SQL Server 2005, you can capture this with event
notifications, or by checking the background trace files. Here is an
example of the latter:
http://sqlblog.com/blogs/aaron_bertrand/archive/2007/01/11/reviewing-autogrow-events-from-the-default-trace.aspx
Otherwise, you should start by telling us version / edition, because the
solution will depend on that.
A
"AF" <af.at.work@.gmail.com> wrote in message
news:1168521633.974360.119620@.i39g2000hsf.googlegr oups.com...
> Is there a way to setup a job to monitor when an autogrow occurs?
>
|||Aaron
Can you provide me what DDL event should I use to capture autogrow file with
Event Notification ?
Thanks
CREATE EVENT NOTIFICATION log_ddl1
ON SERVER --or database
FOR WhatITypeHere
TO SERVICE '//Adventure-Works.com/ArchiveService', 'current database' ;
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:ucgZ2fYNHHA.4848@.TK2MSFTNGP04.phx.gbl...
> If you are using SQL Server 2005, you can capture this with event
> notifications, or by checking the background trace files. Here is an
> example of the latter:
> http://sqlblog.com/blogs/aaron_bertrand/archive/2007/01/11/reviewing-autogrow-events-from-the-default-trace.aspx
> Otherwise, you should start by telling us version / edition, because the
> solution will depend on that.
> A
>
>
> "AF" <af.at.work@.gmail.com> wrote in message
> news:1168521633.974360.119620@.i39g2000hsf.googlegr oups.com...
>
|||Uri Dimant wrote:[vbcol=seagreen]
> AF
> SQL Server Profiler?
>
>
> "AF" <af.at.work@.gmail.com> wrote in message
> news:1168521633.974360.119620@.i39g2000hsf.googlegr oups.com...
Sorry, I meant on a schedule to alert via email ...
|||Aaron Bertrand [SQL Server MVP] wrote:[vbcol=seagreen]
> If you are using SQL Server 2005, you can capture this with event
> notifications, or by checking the background trace files. Here is an
> example of the latter:
> http://sqlblog.com/blogs/aaron_bertrand/archive/2007/01/11/reviewing-autogrow-events-from-the-default-trace.aspx
> Otherwise, you should start by telling us version / edition, because the
> solution will depend on that.
> A
>
>
> "AF" <af.at.work@.gmail.com> wrote in message
> news:1168521633.974360.119620@.i39g2000hsf.googlegr oups.com...
SQL 2000 ENT / WIN2K3 ENT