In previous posts we saw How to install, configure and collect performance data from SQL Server 2005/2008/2008 R2 ? and How to import Performance Data using SQL Nexus ?
In this post we will see How to generate Reports in SQL Nexus
The following are the list of reports available
Blocking and Resource Wait Statistics Report
Bottleneck Analysis Report
Bottleneck Analysis –Drill down sub report
Bottleneck Analysis –Drill down sub report – Wait Statistics
SQL Server 2005 Performance Statistics Reports
Bloaking and Wait Statistics and Bottleneck Analysis reports are linking to Reports we saw earlier
Spinlock Statistics Report – Spinlock is a lightweight, user mode synchronization object used to protect a specific structure. The goal of this report is to see there are no collissions and spin.
SQL Server 2008 Performance Statistics Reports
Blocking and Wait Statistics, Bottleneck Analysis and Spin Lock Stats reports links to the above reports we saw.
Query Hash Report – This report show you the list of queries with details of How many times it executed, How many query plans were created, Total CPU time taken, Total Duration to execute the query and Total Logical IO Reads
Query Hash Report – Performance Overview Drilldown report
Query Hash Report – Top Unique Batches Drilldown charts
Query Hash Report – Top Unique Batches Details report
Query Hash Report – Resource Consumption report
Query Hash Report – Top Unique Batches Details Report
Interesting Events Report shows the number of times events like Auto Stats Updation, Lock Escalation, Missing column statistics, etc… is occurring along with Trace Event ID, you can also drill down into each event and see the query caused the event as well
Interesting Events – Drilldown Report
I hope you all find this information useful… Please post your comments !!!
2 thoughts on “SQL Nexus–How to generate Reports from Performance Data collected and imported ?–Part 3”
Hi , very good One. is the PSSDIAG/SQLDAIG , and SQlnexus tool freeware (can be used by anyone for analyse the servers performance) or is it required any licence from microsoft ? .
No,its completely free diagnostics tool