June 14, 2009 at 10:48 pm
I would like to take some proactive steps and with this regard, I would like to setup alerts on my server to notify me about server's health and performance issues. Is there any article or references on this?
Appreciated if someone please share anything on this?
Thanks,
Cali
June 15, 2009 at 4:05 am
As a starter I would say have a look in Books online under How to: Set Up a SQL Server Database Alert
http://msdn.microsoft.com/en-us/library/ms187827.aspx
There's also a good article at Simple talk
http://www.simple-talk.com/sql/database-administration/sql-server-alerts-soup-to-nuts/
[font="Verdana"]Markus Bohse[/font]
June 15, 2009 at 3:36 pm
Thanks for all your help.
June 15, 2009 at 9:01 pm
Attached to this post is a zip file from the SQL Saturday event in Birmingham, AL. The session was on the preproduction task the speaker does when he touches an SQL Server. It has a script in there for alerts and very useful.
This is the link. I included the link to the download but went ahead and posted it too incase the link dies in the near future. There are some other useful session downloads about disk partitioning and tempdb maintenance. These sessions were by Kevin Boles (MVP).
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
June 23, 2009 at 10:34 am
Thanks Melton,
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply