SQL Nexus, Perf Stats Report

2005 Perf Stats Report for 2008 Data

Continuing our SQL Nexus journey, I noticed another item with the Perf Stats reports.  As I mentioned in a previous post, I imported SQL Server 2008 R2 data into SQL Nexus.  However when I choose the “SQL Server 2008 Perf Stats” report I get the “The database doesn’t have necessary data to run this report” dialog box and when I choose the 2005 report, it opens. 

Here is where it gets interesting, if I right-click on the report I can select the report parameters.  The only parameter is version and the value is 2005.  That’s understandable, so I manually tried to change it to 2008.  Voila!  The report refreshes and now the report title reflects the new value.  This report gives you three choices:  Blocking and Wait Statistics and Bottleneck Analysis, which both have their own reports on the menu, and Spin Lock Stats.  It appears that changing the parameter only changes the title of the report.  I think next week I will crack open these two reports to see why the 2008 data loads in the 2005 report and not in the proper one and what the parameter really does.  Until then, enjoy your weekend!

 

Advertisements

About SQLGator

Florida Gator and Microsoft Data Platform MVP, Star Wars fanatic and is there anything else...oh yeah PS4! I am a geek and SQL Server DBA who dabbles with VMWare, there are other technologies greater than these? Not so fast my friend! I also love to travel to new and exotic places.

Posted on June 1, 2012, in Monitoring and tagged , , , . Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: