I had blogged extensively about System Health Session available in SQL Server 2008 and above. I had also demonstrated how the System Health Session can be used in conjunction with SQL Server Management Studio reports in previous series that I ran on my blog.
System Health Session Dashboard Reports for SQL Server 2008 and SQL Server 2008 R2 – A set of reports available for SQL Server 2008/SQL Server 2008 R2 which provide visualizations for the events tracked by the System Health Session. The reports can be used using the custom reports option in SQL Server Management Studio.
System Health Session Dashboard – Shows the basic information of the information that can be fetched from the System Health Session.
System Health Session Dashboard — sp_server_diagnostics and more – A look into the different issues tracked by the sp_server_diagnostics script and how to build visualizations using that information.
System Health Session Dashboard – sp_server_diagnostics – The basics of what is covered by the sp_server_diagnostics procedure and how to build visualizations on top of the data captured.
System Health Session Dashboard – Error Summary Report
– Shows information on how to write queries to fetch information about various errors tracked by the System Health Session. Shows information tracked by the enhanced System Health Session in SQL Server 2012.
System Health Session Dashboard – Health Summary Report
– Gives you information about the SQL Server instance health like CPU usage, memory etc. A screenshot of the report is shown below:
I have added UTC time formatting so that the time is shown in the same time zone based on the server on which you are viewing the report.
I will keep updating this post once I keep updating with the new reports. As usual, feedback is always welcome.
The report definitions (.rdl) can be downloaded from here.
Can you please give the detailed steps of how to set the value for vServerName parameter. Thanks
That can be done by looking up the parameters in SSDT or BIDS while designing the report. It can be done even from Report Manager. I will add the steps to do that at a later time.
Thanks Amit. Please share the steps.
I have shown how the vServerName parameter can be changed using BIDS or SSDT by importing the RDL file in the following article: http://www.sswug.org/articles/viewarticle.aspx?id=62732
Pingback: SQL Bangalore UG Meet « TroubleshootingSQL