Check performance reports for the database in SQL Server

Monitoring SQL Server performance for database or Server

Check the Standard Reports in SQL Server for analyzing the performance of the Database.

Right-click on database –> Reports –> Standard Reports –> Select the particular report to check like All Transactions, All Blocking Transactions, Disk Usage, Disk usage by the top table, Index Usage Statistics & User Statistics, etc.

Active Monitor on Server

Right-click on the Server and open Active Monitor to see the resource utilization like processor time, waiting for tasks, database I/O, etc

Right-click on Server in SQL Server Management Studio –> Click on Reports –> Click on Standard Reports –> Performance Dashboard, Server Dashboard, Activity- All block transactions, top sessions, top cursors, etc.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.