Instructions: System Health Reporting instructions.docx

Instructions: System Health Reporting instructions.docx

SQL Server 2012 provides a host of diagnostics  in the form of the System Health extended events session which includes sp_server_Diagnostics collection

Here  are a set of Sample reports provide a ‘dashboard’ over the events collected in this session. Key data points covered include:

• Server Health States of various
• CPU and memory utilization
• Blocking
• Long running queries
• Other data around connectivity etc.

Full post and details:  http://blogs.msdn.com/b/sql_pfe_blog/archive/2013/04/15/sql-2012-system-health-reporting-dashboard-visualizing-sp-server-diagnostics-results.aspx