As we continue our SQL Nexus journey, there are a few light things I would like to point out before the long holiday weekend.  We will rejoin this journey probably next week after Memorial Day.

The first thing I noticed, after our debacle with the trace files not loading, was that several of the reports do not work as they should.  After those were resolved, I noticed that some of the reports are not exactly what they state they are.  For example, I connected to a SQL 2008 R2 box and imported the results from a detailed 2008 performance script (see previous posts) and yet when I click on the “SQL Server 2008 Perf Stats” report I get the error below.  That is strange, what is stranger is that when I select the “SQL Server 2005 Perf Stats” report then I get results.  I have talked with other DBAs who have experienced similar problems.  Enjoy your holiday weekend!

Weird SQL Nexus Errors