olahallengren/sql-server-maintenance-solution
SQL Server Maintenance Solution observed · 2026-08-28
Health v2 · maintenance only
77/100
- Activity 99
- Release rhythm 35
- Longevity 100
Flags: no_releases
How is this computed?
round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10) — computed 2026-09-03. Adoption (stars, forks) is never an input.
- gap_med: n/a
- age_days: 3376
- days_rel: n/a
- days_push: 10
- n_releases_24m: 0
Adoption not part of the score
3466 stars · 888 forks observed · 2026-08-28
What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-29, confidence not recorded
A set of T-SQL stored procedures (DatabaseBackup, DatabaseIntegrityCheck, IndexOptimize) plus SQL Agent jobs for backing up, integrity-checking, and maintaining indexes and statistics on Microsoft SQL Server. It is the de facto industry-standard maintenance solution, supporting SQL Server 2017-2025 and Azure SQL.
Use cases
- schedule sql server backups
- run dbcc checkdb integrity checks on all databases
- rebuild and reorganize indexes and update statistics
- automate sql server database maintenance jobs
- maintain azure sql database indexes and statistics
- log and monitor maintenance command execution
When to choose
- you administer SQL Server 2017-2025 or Azure SQL and need reliable, battle-tested backup and maintenance automation
- you want fine-grained options for backup, integrity check, and index maintenance in mission-critical environments
When to avoid
- you use a database engine other than Microsoft SQL Server
- you need a GUI-based maintenance tool rather than T-SQL scripts and SQL Agent jobs
Facets
library · maturity stable
database backup scheduling logging developer-tools databases self-hosted windows cloud self-hosted sql-server tsql database-maintenance dbcc index-maintenance stored-procedures azure-sql devops automation
2 sources
- readme: https://github.com/olahallengren/sql-server-maintenance-solution · fetched 2026-08-28 · 752e8625a32a
- homepage: https://ola.hallengren.com · fetched 2026-08-29 · 852d7d6971c9
Member repositories
| Repository | Role | Health v2 |
|---|---|---|
| olahallengren/sql-server-maintenance-solution | main | 77 |
For agents
markdown · JSON · MCP: product_card(name="olahallengren/sql-server-maintenance-solution")
Data as of 2026-08-30T08:39:29.467469+00:00 · Report a problem