dbachecks is a module that combines several modules into a highly configurable SQL Server health-tracking/maintenance solution. It builds on three separate modules, as follows:
- dbatools for SQL commands
- Pester for the Test Framework it provides
- PSFramework for managing configuration and internal infrastructure
In effect, it consists of dozens of checks-sets of Pester tests—that each ensures a specific health criterion, such as orphaned files, storage, network latency, correct Service Principal Names in AD, and so on.
Each can be executed individually, or in tag-based groups:
# Execute only the PowerPlan check
Invoke-DbcCheck -Check PowerPlan
# Execute all instance-related checks
Invoke-DbcCheck -Check Instance