December 23, 2010 at 1:12 pm
Currently I just have alerts to fire for Severity 017-025 errors, error 833 (disk I/O timeouts) and error 825 (info about that one here http://www.sqlskills.com/BLOGS/PAUL/post/A-little-known-sign-of-impending-doom-error-825.aspx)
What alerts do you guys have configured?
Id like to add some alerts based on log growth/db growth but am still figuring out the best way since my box has 30+ db's and counting.
January 6, 2011 at 12:16 am
I would suggest adding Severity 14 alerts to detect login issues if you have set ‘Failed Logins’ auditing at the SQL instance level.
Below shows the Severity 14 login failure alerts you would get notified on:
SELECT *
FROM master.sys.messages
WHERE severity = 14
AND language_id = 1033 -- English
AND is_event_logged = 1
Severity 16 also has several logged events which may be on interest.
I would also suggest reviewing master.sys.messages to see if there are more specific alerts which are of interest to you.
January 6, 2011 at 2:13 am
Disk Space
Blocks
Long running queries
IO's of all platforms
Outdated backups
Job Failures
Excessive failed logins (hack attempts)
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 6, 2011 at 2:51 am
we have no alerts configured in sqlserver for this, but our windows eventlog monitoring tool captures it and raises alerts in HPOpenview.
It is an easy way to use alerts to track this kind of critical stuff when you have no other monitoring tool.
btw we use user defined alerts for other purposes. e.g. to launch sqlagent jobs to perform async operations.
to capture failed logins, we use sqlserver events so we get all available info of the failed connection.
EVENT NOTIFICATION N_Failed_Login_Notification ON SERVER FOR AUDIT_LOGIN_FAILED
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply