July 25, 2014 at 3:30 am
Hi Team,
I need help on setting up threshold alerts when the database (files MDF & LDF) reaching the MAX size.
I mean when the files are nearing max sizes. how to implement it.
If there is any good blog post or Any Scripts for implementing these alerts. please suggest me
Looking for scripts to configure the MDF and LDF size was reaching around 80 % giving alert like warnings and reaching the size around 90-100% Critical alerts like that
Request to you guys please share any scripts on these.
really helpful to me Thanks in Advance.
July 25, 2014 at 3:57 am
You can set up an alert in SQL Server Agent based on the Log File Size and Data File Size counters in the Databases performance object.
John
July 25, 2014 at 4:36 am
see this article: http://www.sqlservercentral.com/articles/alerts/89885/ on how to create an alert. From SSMS you can script the actions just before clicking the final [OK] or you can script the object when it is created.
July 25, 2014 at 8:43 am
there are steps that you need to take before you setup alerts on sql agent for them to work.
1. setup database mail - http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/
2. setup an operator to send alerts - http://www.mssqltips.com/sqlservertip/1523/how-to-setup-sql-server-alerts-and-email-operator-notifications/
3. create the sql agent job that will send you alerts (unless one is already setup go under notifications and setup your opertator)
4. create the notification alert on the sql agent job - http://msdn.microsoft.com/en-us/library/ms190038.aspx
MCSE SQL Server 2012\2014\2016
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply