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