July 6, 2012 at 7:41 am
I would like to create alert jobs in case anything goes wrong.
-- Need an alert if Parallelism value changes to 0 during business hours. Currently it is set to
4.
--Need an alert if TempDB files size changes. They all are same size right now.
--Need an alert if any database file or log file gets within 10% of its size.
Please let me know if there are any ideas.
July 6, 2012 at 9:27 am
This might help: http://www.sqlservercentral.com/articles/Administration/sqlserveralerts/1435/
In terms of changing settings, alerts don't detect this. You'd be better off using Policy Based Management to prevent, or alert you when these occur (DOP/tempdb).
For size alerts, use performance based alerts.
http://www.sqlservercentral.com/articles/Administration/smtpsqlserverperformancealerts/2005/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply