SQL Nexus, Quirkiness Workaround

SQL Nexus Report Options

SQL Nexus Report Options

Yesterday, I wrote about the “Realtime – Server Status” report quirkiness where essentially the report does not work when you import SQL Server 2008 data and essentially it does not contain any information as to why it does not work, only a blank screen.  Craig Purnell (Blog | Twitter) shortly thereafter sent me an updated report library file that works with 2008.  That is exciting!  I ran a diff on the two files and found that Craig updated two lines with the same change in order for this to work.  The filename  is “Realtime – Server Status.rdl” located in the Reports subfolder of your SQL Nexus installation folder.  Below is the line that needs to be changed (remember to do it in both places):

Original line:  SELECT @ts_now = cpu_ticks / CONVERT (float, cpu_ticks_in_ms) FROM sys.dm_os_sys_info

Updated Line:  SELECT @ts_now = ms_ticks FROM sys.dm_os_sys_info

Thanks Craig, now I have results that look like the following:

Realtime Server Status

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 May 31, 2012, in Monitoring, Troubleshooting and tagged , , , , . Bookmark the permalink. 1 Comment.

  1. Glad I could help. I like your posts about SQL Nexus. It adds value to a poorly documented but valuable tool.

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: