How the Site Fits Together

The reference pages, the script areas under DBA Scripts, and the incident pages that route you into them.

How sqldba.blog fits togethersqldba.blog homeSTART FROM WHAT YOU NEEDSCRIPT AREAS, UNDER DBA SCRIPTSError LibraryThe error you are facingWait Types LibraryWhat SQL Server is waiting onDBA ScriptsCopy/paste scripts for the jobSSMS Complete GuideThe tool you work in all daySQL Server BuildsPatch levels and support datesServer &ConfigurationServer InventorySQL ServerInstallationConfig ScorePatch LevelStorage & CapacityDisk Space on SQLServerDatabase SizesGrowth EventsGrowth ForecastBackup & RecoveryBackup CoverageRestore TimeEstimateRestore HistoryBackup ChainIntegrityHigh AvailabilityAG Replica StateAG FailoverReadinessReplication StatusLog ShippingStatusPerformance &TroubleshootingQueryBlocking andLockingExtended EventsTracingCollectorsSecurityLogin PermissionsLogin SecurityAuditSysadmin MembersCertificates andTDEMaintenance &AutomationSQL Agent and JobsIndex MaintenanceSQL ServerMaintenance JobFrameworkMigration &DeploymentSQL ServerMigration ScriptGeneratorsMigration RiskIN AN INCIDENT? START FROM THE SYMPTOMCannot ConnectLogin FailedSQL Server Is SlowHigh CPUBlockingDisk or Log FullTempDB Is FullBackup or RestoreAgent Job Failedpillarmost-used script

Swipe sideways inside the map to see all of it.

The same map as a list

Server & Configuration: Server Inventory, SQL Server Installation
Storage & Capacity: Database Sizes, Transaction Log Size
Backup & Recovery: Backup Chain Integrity, Backup Coverage
High Availability: AG Replica Role, AG Failover Readiness
Performance & Troubleshooting: Query, Blocking and Locking, Extended Events Tracing, Collectors
Security: Permissions, Sysadmin Members
Maintenance & Automation: SQL Agent and Jobs, Index Maintenance, SQL Server Maintenance Job Framework
Migration & Deployment: SQL Server Migration Script Generators