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.googlegroups.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.googlegroups.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.googlegroups.com...
>> Is there a way to setup a job to monitor when an autogrow occurs?
>|||> Can you provide me what DDL event should I use to capture autogrow file
> with Event Notification ?
Well, it's not a DDL event, it's a trace event (DATA_FILE_AUTO_GROW or
LOG_FILE_AUTO_GROW).
See:
http://msdn2.microsoft.com/en-us/library/ms190655.aspx|||Uri Dimant wrote:
> AF
> SQL Server Profiler?
>
>
> "AF" <af.at.work@.gmail.com> wrote in message
> news:1168521633.974360.119620@.i39g2000hsf.googlegroups.com...
> > Is there a way to setup a job to monitor when an autogrow occurs?
> >
Sorry, I meant on a schedule to alert via email ...|||Aaron Bertrand [SQL Server MVP] wrote:
> 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.googlegroups.com...
> > Is there a way to setup a job to monitor when an autogrow occurs?
> >
SQL 2000 ENT / WIN2K3 ENT