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
No comments:
Post a Comment