SQL Server Management Studio Standard Reports – Server Dashboard

SQL Server Management Studio Standard Reports – Server Dashboard

Rate This
  • Comments 6

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.

 

Leave a Comment
  • Please add 5 and 6 and type the answer here:
  • Post
  • PingBack from http://www.artofbam.com/wordpress/?p=6816

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

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

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

  • 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?

  • 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

Page 1 of 1 (6 items)