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.