Part 3: Analyze SQL Profile traces with a SSRS dashboard. The reports itself

As described in my previous blogpost Part 1 and Part 2, I started a series in which I will explain how you can make a dashboard in SQL Reporting Services to analyze your SQL Server Profiler traces. In this last blogpost I will supply all reports for dashboard.

This dashboard contains 13 reports and can be downloaded from here:

1. TracePerformanceOverview. This is the dashboard itself. It is the starting point of your analyze. It contains links to all other 12 reports.
2. ApplicationTOPXCPU: Overview of CPU usage grouped by application.
3. ApplicationTOPXReads: Overview of Reads grouped by application.
4. ApplicationTOPXTimeSQL: Overview of SQLDuration grouped by application.
5. ApplicationTOPXWrites: Overview of Writes grouped by application.
6. RepeatingTOPXCPU: Overview of recurring queries summarized by CPU.
7. Repeating TOPXReads: Overview of recurring queries summarized by Reads.
8. Repeating TOPXTimeSQL: Overview of recurring queries summarized by SQL Duration.
9. Repeating TOPXWrites: Overview of recurring queries summarized by Writes.
10. TOPXCPU: Overview of queries ordered by CPU usage.
11. TOPXReads: Overview of queries ordered by Reads.
12. TOPXTimeSQL: Overview of queries ordered by SQL Duration.
13. TOPXWrites: Overview of queries ordered by Writes.

• Deploy all these reports to your reporting server in one folder. The reports are made on a SQL 2008 R2 Reporting server. Therefor they can only be deployed on a SQL 2008 R2 Reporting server. If you deploy it on a SQL 2008 Reporting server you can get next error:  [rsInvalidReportDefinition] The report definition is not valid. Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' which cannot be upgraded.
• Create a Data source on your reporting server named: ExactPerformanceAnalyze

 Enjoy using the dashboard. Please leave a comment if you have questions or suggestions.

Tweet