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 Reporting Services. Since the existing set of reports which I had published could be viewed from SQL Server Management Studio using the custom reports option, the reports had to conform to SQL Server 2005 Report schema. This in turn meant that I couldn’t make use of the new controls or cascading parameters features for these reports. This is the entire reason why I am starting a new series wherein you can use the solution mentioned to deploy to a SQL Server 2008 R2 Reporting Services instance and view the system health session reports for all the SQL Server 2008 and above instances in your environment.
Read this article..
Amit currently works as a Premier Field Engineer at Microsoft specializing in proactive and advisory assistance for SQL Server environments.
In the past, Amit was part of the SQL Server Escalation Services team at Microsoft. His day-to-day work involves fixing and troubleshooting complex issues related to SQL Server over a varied range of environments, which could be a deployment handling just 100 users or 10 million users.
Over the years, he has learned various ways of slicing and dicing diagnostic data collected for troubleshooting and picked up a few tricks & tid-bits about the internals of this ever-evolving product called SQL Server.
For more information about Amit, visit his blog at http://troubleshootingsql.com.
comments powered by