SQL Server – DMV’s

--sys.dm_os_ = SQL Server OS Information

SELECT​​ *​​ FROM​​ sys.dm_os_wait_stats

--sys.dm_io_ = i/O Information

SELECT​​ *​​ FROM​​ sys.dm_io_pending_io_requests

--sys.dm_exec_ = Session & Query Information

SELECT​​ *​​ FROM​​ sys.dm_exec_sessions

SELECT​​ *​​ FROM​​ sys.dm_exec_requests

--sys.dm_db__ = Database & Index Information

SELECT​​ *​​ FROM​​ sys.dm_db_task_space_usage

SELECT​​ *​​ FROM​​ sys.dm_db_index_operational_stats(NULL,​​ NULL,​​ NULL,​​ NULL)

SELECT​​ *​​ FROM​​ sys.dm_db_index_physical_stats(DB_ID(),​​ NULL,​​ NULL,​​ NULL,​​ 'DETAILED')