This project is read-only.

Query Hash Reports don't work properly


Hi all,
I have a minor problem with the Query Hash Report.
I can only view the Top Queries by CPU. If I choose Duration or Logical Reads, then the report fails with a large exception message (see attached screenshot)
Any ideas how to fix this?

file attachments


amitban wrote Jan 9, 2011 at 10:37 AM

The Query Hash data gets collected by the SQL Server 2008 Perf Stats script. It is collected during shutdown of the data collector. If the tool shutsdown before that data is collected, then the report will not be available for the Top Queries by CPU. This is what looks like happened. It happens when there is a lot of data to collect. You can correct that by running the SQL 2008 Perf Stats Snapshot script manually and then importing the data into SQL Nexus.

wrote Feb 22, 2013 at 12:49 AM