Re: Autogrowth for database

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Anushi (anonymous_at_discussions.microsoft.com)
Date: 12/21/04 

Date: Tue, 21 Dec 2004 15:52:48 +0530

Firstly, this is the wrong NG for the post... please choose the SQL groups
for such posts next time :-)

Now, if you want an alert when an autogrowth occurs on your database, the
closest available counters for this kind of event are
1. The SQL Server:Access methods object - Extent Allocations and
2. The SQL Server:Databases object - Log Growths

You can access these counters and create alerts/actions for them through
either the performance monitor or the SQL Server Enterprise
Manager\Management\SQL Server Agent\alerts interface.

HTH,

Anushi

"SK" <SK@discussions.microsoft.com> wrote in message
news:28E9A2D8-8D11-4435-8701-F505B08C06B4@microsoft.com...

> Hi,
>
> As the database file reaches the maximum size limit, filegrowth will
happen
> if autogrowth is set. May I know is there a log or something that I can
see
> when is the autogrowth happening and the details of this event?
>
> thanks in advance
>
> SK