How olahallengren/sql-server-maintenance-solution works
This repository is a SQL Server maintenance solution delivered as installable SQL scripts and separate stored-procedure scripts. Its documented maintenance stages are database backup, integrity checking, and index/statistics maintenance; each uses CommandExecute to run and log commands. CommandLog is an optional logging table, while Queue and QueueDatabase support parallel database processing. The README describes the installers’ scope and component dependencies; source excerpts were unavailable, so relationships beyond those documented are omitted.
Main entry points: MaintenanceSolution.sql Full installer · CommandExecute.sql Command execution · DatabaseIntegrityCheck.sql Integrity check · IndexOptimize.sql Index maintenance
Components 10
Installation
- Full installer
MaintenanceSolution.sql - Azure DB installer
MaintenanceSolutionAzureSQLDatabase.sql
Maintenance
- Database backup
DatabaseBackup.sql - Integrity check
DatabaseIntegrityCheck.sql - Index maintenance
IndexOptimize.sql
Execution and logging
- Command execution
CommandExecute.sql - Command log
CommandLog.sql
Parallel processing
- Processing queue
Queue.sql - Database queue
QueueDatabase.sql
Other components
- SQL Server operator
Connections 12
- Full installer → Database backup: installs
README.md - Full installer → Integrity check: installs
README.md - Full installer → Index maintenance: installs
README.md - Full installer → Command execution: installs
README.md - Full installer → Command log: installs
README.md - Full installer → Processing queue: installs
README.md - Full installer → Database queue: installs
README.md - Azure DB installer → Integrity check: installs
README.md - Azure DB installer → Index maintenance: installs
README.md - Database backup → Command execution: uses
README.md - Integrity check → Command execution: uses
README.md - Index maintenance → Command execution: uses
README.md