Learn PowerShell Core 6.0

Working with the dbachecks module

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 checkInvoke-DbcCheck -Check PowerPlan# Execute all instance-related checksInvoke-DbcCheck -Check Instance ...