SQL Server - Monitoring Key Metrics and Keyboard Shortcuts

( / )

Note:- There will be "Victory for Sure" if we just concentrate our work.

Related articles..

Surface Area Configuration

https://learn.microsoft.com/en-us/sql/relational-databases/security/surface-area-configuration?view=sql-server-ver16

Versions

https://learn.microsoft.com/en-us/troubleshoot/sql/releases/download-and-install-latest-updates

Keys and Constraints

https://learn.microsoft.com/en-us/sql/relational-databases/tables/primary-and-foreign-key-constraints?view=sql-server-ver16

                                                                 ( \ )

Other Useful Links - SQL Server Monitoring Key Performance Indicators.

https://learn.microsoft.com/en-us/biz    /technical-guides/test-results-sql-server-key-performance-indicators

https://learn.microsoft.com/en-us/sql/ssms/sql-server-management-studio-keyboard-shortcuts?view=sql-server-ver16

In addition to this...Please also read

SQL Server Monitoring Key metrics

- Open Transaction using DBCC

- CPU Utilisation.

- High CPU Queries

- WaitType Analysis.

- Blocking/Deadlocks.

- DB Wise Fragmentation.

- Index Usage Stats

- Long Running Jobs/Jobs currently being executed.

- PerfMon / DMV Performance Counters.

- SQL and Agent Error Logs

In this category, you can search metrics for:

T-SQL queries
The buffer cache
Table-related resources
Locks
Resource pools
Indexes
Connections

Group By Clause

https://learn.microsoft.com/en-us/sql/t-sql/queries/select-group-by-transact-sql?view=sql-server-ver16

Best Regards Always

Amit Vaid