Category Archives: MSSQLServer

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.