This Missing Index Script ranks the indexes SQL Server wishes it had by a plain score and builds a CREATE INDEX statement for each. Read the key order, the INCLUDE list and the overlap before you create one. A garden center orders table shows the logical reads drop from 3,138 pages to 3.
Page Density: The Fragmentation Number That Actually Slows Scans
Measure page density and fragmentation, compare scan reads around a test rebuild, and choose fill factor using workload evidence.
Recording Table Row Counts Every Day
Recording table row counts each day creates a useful SQL Server trend when a scheduled job, history table, and change review support it.
SQL SERVER – Finding Last Backup Time for All Database
Last Backup Time comes from recorded history, which I check by backup type. Recovery still needs the files and a tested chain.
Find the Last Read and Write Time of Every Table in SQL Server
Find the last read and write time of every table in SQL Server with sys.dm_db_index_usage_stats. The tests show what counts as a read, why an insert counts as a write, what an index rebuild does to the numbers, and what wipes them.
SQL SERVER – Find Total Number of Transactions on Interval
How many Transactions run on your server per minute? A handy script reads sys.dm_os_performance_counters twice with a WAITFOR DELAY between the reads.
Monitoring Availability Group Health
Monitor availability group health through replica connection state, database synchronization, send and redo queues, and failover readiness checks.