Dynamic management views and DBCC commands are two foundations of SQL Server administration. DMVs answer questions about current and accumulated engine state, while DBCC offers specific database-console operations.
Dynamic management views
Examples include sys.dm_exec_requests for active requests, sys.dm_os_wait_stats for aggregate waits, and sys.dm_db_index_usage_stats for index-use indicators. Some values reset; permissions differ by version.
DBCC commands
DBCC CHECKDB assesses logical and physical consistency; DBCC CHECKTABLE targets a table. Other DBCC commands have very different effects, so learn each syntax and risk separately.
A short diagnostic query
SELECT session_id, command, status, wait_type
FROM sys.dm_exec_requests
WHERE session_id > 50;How to learn safely
Begin with supported read-only queries against a development instance. Read the documentation for your SQL Server version; measure collection overhead and check permissions before attempting checks against live systems.
Next steps
Study Query Store, Extended Events, actual execution plans, restore drills, and how to use diagnostic results to form a verifiable hypothesis.
AI content and reuse notice: Written using AI based on this site’s earlier post (22513), with added explanations and examples. The newly generated text may be reused, edited, or republished with or without attribution. Third-party works and trademarks remain subject to their own rights. AI can make mistakes. Check all code, version-specific features, and operational decisions against current vendor documentation before production use.
