Standard Reports in SQL Server Management Studio

In SQL Server Management Studio you can use Standard Reports for monitoring system activity, statistics and performance.

To use Server Standard Reports:
Connect to SQL Server Instance -> Right Click on instance name -> Click Reports -> Click Standard Reports -> Choose Report:

You can use one of the following Server Standard Reports:

Server Dashboard
Configuration Changes History
Schema Changes History
Scheduler Health
Memory Consumption
Activity – All Blocking Transactions
Activity – All Cursors
Activity – Top Cursors
Activity – All Sessions
Activity – Top Sessions
Activity – Dormant Sessions
Activity – Top Connections
Top Transactions by Age
Top Transactions by Blocked Transactions Count
Top Transactions by Locks Count
Performance – Batch Execution Statistics
Performance – Object Execution Statistics
Performance – Top Queries by Average CPU Time
Performance – Top Queries by Average IO
Performance – Top Queries by Total CPU Time
Performance – Top Queries by Total IO
Server Broker Statistics
Transaction Log Shipping Status

To use Database Standard Reports:
Connect to SQL Server Instance -> Right Click on a Database -> Click Reports -> Click Standard Reports -> Choose Report:

You can use one of the following Database Standard Reports:

Disk Usage
Disk Usage by Top Tables
Disk Usage by Table
Disk Usage by Partition
Backup and Restore Events
All Transactions
All Blocking Transactions
Top Transactions by Age
Top Transactions by Blocked Transactions Count
Top Transactions by Locks Count
Resource Locking Statistics by Object
Object Execution Statistics
Database Consistency History
Index Usage Statistics
Index Physical Statistics
Schema Changes History
User Statistics

To use SQL Server Agent Standard Reports:
Connect to SQL Server Instance -> Right Click on SQL Server Agent -> Click Reports -> Click Standard Reports -> Choose Report:

You can use one of the following SQL Server Agent Standard Reports:

Job Steps Execution History
Top Jobs

To use Logins Standard Reports:
Connect to SQL Server Instance -> Right Click on Logins -> Click Reports -> Click Standard Reports -> Choose Report:

You can use one of the following Logins Standard Reports:

Login Statistics
Login Failures
Resource Locking Statistics by Logins

To use Management Standard Reports:
Connect to SQL Server Instance -> Right Click on Management -> Click Reports -> Click Standard Reports -> Choose Report:

You can use one of the following Management Standard Reports:

Tasks
Number of Errors

Here is an example of Disk Usage Database Standard Report:

You can use SQL Server Profiler to capture the TSQL query used to create these standard graphical reports.

If the post helped you, please share it:
Pin It

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">