This project is read-only.


Realtime Server Status report does not work when connecting to SQL 2008


Reason: Column cpu_ticks_in_ms of view sys.dm_os_sys_info was replaced with ms_ticks in SQL 2008 and higher.
SQL Nexus Version:
I researched into this since I used this report frequently for monitoring our servers and kind of fixed it for myself by modifying the Report until seemed to work (although I am not sure if the data being returned now is really correct, someone will still have to verify this).
I am providing my modified version as attachment. Tested with SQL 2005 and 2008 R2.
I'd be happy if my modifications turn out to be correct and if they would make it into a future SQL Nexus release.

file attachments


amitban wrote Nov 9, 2010 at 5:28 PM

Thanks for the submission. We have discontinued RealTime Server Status report from SQL Nexus v3.0. Looks like you have some old RDL files left over from the previous version. It can be cleaned up from the following folder: %appdata%/sqlnexus/reports
The same functionality is provided by "Server Dashboard" standard report in SSMS.

wrote Nov 9, 2010 at 5:29 PM

ecce2k wrote Nov 10, 2010 at 10:46 AM

Hmm, I don't think so, I can still find the Realtime Server Report RDL in the current zip on your page.
And a clean install of also still shows the report available in the reports list...

amitban wrote Nov 10, 2010 at 4:22 PM

Thanks for pointing it out. We are planning to discontinue the feature in the next release. I shall keep this discussion thread in mind in case we intend to put that feature back into the product in a future release. Thanks once again.

wrote Feb 22, 2013 at 12:49 AM

wrote May 16, 2013 at 12:18 PM

wrote May 16, 2013 at 12:18 PM

wrote Jun 14, 2013 at 8:28 AM