Setting Transaction Log alerts

The other day, one of our developers (who’s preparing to be a DBA, by the way– whoo!) asked me how to set up an alert if the transaction log grows alarmingly. Now I searched SQL Server Agent>Alerts inside SQL Server management studio, but couldnt find this. Recently, I found that this is possible through the Windows tool named "Performance" which you can open by typing "perfmon" in Start>Run.

There is a section called "Performance Logs and Alerts" which you need to expand. This lets you define a new alert.


There are various counters here that you can use. The one of interest to us is "MSSQL$2005:Databases. This counter has various counters which you can read online, so I am not repeating that here. I selected the "Log Growths" parameter for a specific database (named gLock).


You can set this to an appropriate value and set it to do various actions that you define.

Hope this was useful…

UPDATED ::!5257C6E71B41D7BA!578.entry 

This entry was posted in Transaction Logs. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s