SQL – 2008 – Services
Monitor Set – SQL 2008 – Critical Services
MSSQLSERVER, MsDtsServer100, MSSQLFDLauncher, ReportServer, SQLWriter
Also monitors – sqlservr.exe process for “Down” transition.
DISCLAIMER: All Monitor sets should be used as a guideline. Thresholds set, may not be suitable for your exact environment. What works for large clients, may not work for small ones, and vice-versa. Once you assign the monitor set, review the data and make any adjustments you feel are necessary for your environment.