LinkedIn | FaceBook | Twitter
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:
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.
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
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.
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.
Shows the default Collation for the instance.
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.
Allows the SQL Server Agent to use Extended Stored Procedures. 0 = No, 1 = Yes.
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.
Allows the xp_cmdshell extended stored procedure to run operating system tasks. 0 = No, 1 = Yes.
Shows how many sessions are in use. Hit the Refresh icon to show the latest value.
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.
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.
Shows how many sessions are connected but not doing anything. Hit the Refresh icon to show the latest value.
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.
Shows how many traces (collection events) are running against the Instance. Hit the Refresh icon to show the latest value.
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.
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