SQL Server Management Studio Standard Reports – Server Dashboard - Carpe Datum - Site Home

I’m continuing a series on the Standard Reports you can find in SQL Server Management Studio (SSMS).

(Note: These reports only work against SQL Server 2005 and higher. They don’t run against the lower versions because those don’t have all the management objects the reports depend on.)

The first blog in the series is here:

http://blogs.msdn.com/buckwoody/archive/2007/10/09/sql-server-management-studio-standard-reports-overview.aspx

To find this report, open SSMS, right-click a Server, and then select “Reports” and then “Standard Reports”. This report doesn’t take a long time to render. As we start, I should note that you can print reports, but you can’t select the text from a report (as of this writing, anyway). You could always install the “Text” printer and print the report to that.

The Server Dashboard report shows some of the primary properties for a server and has a couple of graphs. Here’s a quick chart of what properties it shows. I’ll also include other references to these settings if I can locate them all – just click the “Item”. Note that the “Non Default Configuration Options” shows what you’ve changed from the default settings.

Area	Item	Description
Configuration Details	Server Startup Time	Shows the last time the instance was restarted. This might be different from the server’s hardware startup time if SQL Server is restarted manually.
	Server Instance Name	Shows the name of the server instance
	Product Version	This is a number that shows the exact build of SQL Server. Click on the link to the left to find out what those are.
	Edition	Shows the edition of SQL Server for the Instance.
	Windows Process ID	Shows the Windows Process ID for this Instance of SQL Server. Changes when you stop and start the SQL Services.
	Scheduler Agent Jobs	Shows the number of installed jobs, not what is running.
	Server Collation	Shows the default Collation for the instance.
	Is Clustered	1 = Instance is Clustered, 0 = Instance is not Clustered.
	Is FullText Installed	1 = Full Text Engine is enabled, 0 = Full Text Engine is not enabled.
	Is Integrated Security Only	1 = Only Windows accounts are used, 0 = Windows and SQL Server accounts are used.
	Is AWE Enabled	AWE is a type of memory setting. 1 = AWE is enabled, 0 = AWE is not enabled.
	# of Processors (used by instance)	Shows the number of reported processors SQL Server is configured to use. Not Hyperthreading aware.
Non Default Configuration Options	Ad Hoc Distributed Queries	Allows “Ad Hoc” queries from remote systems. 0 = No, 1 = Yes.
	Agent XP's	Allows the SQL Server Agent to use Extended Stored Procedures. 0 = No, 1 = Yes.
	clr enabled	Allows the Common Language Runtime to work in SQL Server. 0 = No, 1 = Yes.
	Database Mail XPs	Enables Database Mail. 0 = Not enabled, 1 = Enabled.
	min server memory (MB)	Sets the minimum amount of memory SQL Server uses.
	Ole Automation Procedures	Allows OLE operations to be called from within SQL Server Transact SQL batches. 0 = No, 1 = Yes.
	remote admin connections	Allows the Dedicated Admin Connection (DAC) to work from a remote system. 0 = Local Only, 1 = Remote and local.
	SQL Mail XPs	Enables SQL Mail for the Instance. 0 = Not enabled, 1 = Enabled.
	Web Assistant Procedures	Allows SQL Server to create Web Pages. 0 = No, 1 = Yes.
	xp_cmdshell	Allows the xp_cmdshell extended stored procedure to run operating system tasks. 0 = No, 1 = Yes.
Activity Details	Active Sessions	Shows how many sessions are in use. Hit the Refresh icon to show the latest value.
	Active Transactions	Shows how many transactions (A sequence of operations performed as a single logical unit of work) are in use. Hit the Refresh icon to show the latest value.
	Active Databases	Shows the number of databases marked as active on the system. Hit the Refresh icon to show the latest value.
	Total Server Memory (KB)	Shows how much memory the Instance is using. Hit the Refresh icon to show the latest value.
	Idle Sessions	Shows how many sessions are connected but not doing anything. Hit the Refresh icon to show the latest value.
	blocked Transactions	Shows how many transactions are blocked by another process. Hit the Refresh icon to show the latest value.
	Distinct Connected Logins on Sessions	Consolidates the connections into unique values only. Hit the Refresh icon to show the latest value.
	Traces Running	Shows how many traces (collection events) are running against the Instance. Hit the Refresh icon to show the latest value.
Graphs	CPU Usage (%)*	A pie graph that shows, by database (cumulative) or Ad-hoc query, the percentage of CPU in use by SQL Server. Hit the Refresh icon to show the latest value.
	Logical IO Performed (%)* pie, By database (cumulative) or Ad-hoc queries	Hit the Refresh icon to show the latest value.