Inspect LastGoodCheckDbTime for each database, flag stale or unavailable checks, and compare metadata with retained integrity-job evidence.
Read-Only Routing for Availability Group Replicas
Configure availability group read-only routing, listener connections, replica URLs, balanced lists, and verification after failover.
Recovery Model Changes and the Log Backup Chain
Explain the log backup chain across FULL and SIMPLE changes, inspect recovery LSNs and backup history, and establish a new backup boundary.
Latch Waits at the Top: Reading sys.dm_os_latch_stats
Sample SQL Server latch waits by class, then connect ACCESS_METHODS_DATASET_PARENT, FGCB_ADD_REMOVE, and LOG_MANAGER to the next check.
Checking SQL Server Service Startup Type and Status From T-SQL
Inspect service startup type, current status, service account, and SQL TCP registry values, then compare configuration with live listeners.
Logon Storms: Protecting SQL Server From Connection Floods
Diagnose SQL Server logon storms, control connection growth, test a limited logon trigger, and preserve administrator recovery access.
Searching the Error Log by Date and Text With xp_readerrorlog
Search the SQL Server error log by date and text, select archives, capture matching rows, and cycle logs without losing context.