System Health Session Dashboard – sp_server_diagnostics and more In my last article, I showed how to fetch the sp_server_diagnostics output from the System Health Session and utilize that information to create dashboard reports. A screenshot below shows the information component state summary matrix from a SQL Server instance. In this post, we will look at how to get information from...

System Health Session Dashboard – sp_server_diagnostics In my previous posts on the System Health Session, I have been demonstrating how to use the default System Health Extended Events session to build reports that can be deployed to your Report Server instance. In this post, I shall discuss the new system stored procedure, sp_server_diagnostics, which was introduced in SQL Server 2012...

System Health Session Dashboard – Health Summary Report In the last post of this series, I discussed about how to get information about errors reported by the System Health Session for SQL Server 2008 and above instances. Additionally, I demonstrated how connectivity and security errors are tracked using separate Extended Events in SQL Server 2012. In this post, we shall...

System Health Session Dashboard – Error Summary Report In the first post of this series, I had talked about displaying the events reported by the system health session extended session on SQL Server 2008 versions and higher. The next set of reports will show the errors which by the error_reported extended event. The query which I used to fetch the...

System Health Session Dashboard I had written a series on how to create reports based on the system health session for SQL Server 2008 and above instances in the recent past. I got a lot of positive feedback regarding the reports which got me thinking on how to make this available using the new features of SQL Server 2008 R2...