SQL Server Management Studio Standard Reports – Server Dashboard






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.


 


Comments (6)

  1. Carpe Datum says:

    I’ve completed documenting all of the Standard Reports in SQL Server Management Studio. You can get to

  2. Mike says:

    On the CPU Usage Pie Chart, is there a way to tell what queries are included in adhoc?

  3. BuckWoody says:

    Mike, no, they don't go that in-depth. Check out SQL Server 2008's Management Data Warehouse for that sort of thing.

  4. Robert Martelli says:

    You said: "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."

    Now, this is cumulative as to what period?

    The period since the start of the instance?

  5. Mike Ladwig (mikeladwig@t-online.de) says:

    The overview of the reports is great. Can you perharps tell me a book where it's written down AND the real sense, mean where I find tips/information  what to do in which case, – as example space for logs is more than x-percent…

    thanks for answer in advance

    Mike

Skip to main content