SQL Server - Monitoring Mostips

Monitoring Mostips

It has been observed that most of the people do not consider all the Monitoring Mostips / Tools that most of the time required by the DBAs.

Let me specify one by one.

1. Performance Monitor / PerfMon.

2. SQL Server DMV of Performance Counters.

https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-os-performance-counters-transact-sql?view=sql-server-ver16

3. sys.sysprocesses, sys.dm_exec_sessions and sys.dm_exec_requests, sys.dm_os_waiting_tasks for Blocking and WaitTypes.

4. SQL Server Trace/Profiler.

Related Articles
a) https://learn.microsoft.com/en-us/sql/relational-databases/sql-trace/sql-trace?redirectedfrom=MSDN&view=sql-server-ver16
b) https://support.microsoft.com/en-us/topic/how-to-use-sql-profiler-to-create-a-sql-trace-in-microsoft-sql-server-b8d41588-04b2-e121-f598-e0991cf0b6f1
c) https://learn.microsoft.com/en-us/sql/tools/sql-server-profiler/start-sql-server-profiler?view=sql-server-ver16
d) https://learn.microsoft.com/en-us/sql/tools/sql-server-profiler/view-and-analyze-traces-with-sql-server-profiler?view=sql-server-ver16


5. DBCC Opentran
6. Log Shipping Monitor
7. Activity Monitor
8. Virtual Logs from sys.dm_db_log_info
9. WaitType Analysis
10. Index Fragmentation
11. Long Running Jobs/Jobs currently being executed.


Best Regards

Amit Vaid

Popular Post

https://amit-sqldbasupport.blogspot.com/2022/12/sql-server-dba-sankalp.html