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 check
Invoke-DbcCheck -Check PowerPlan

# Execute all instance-related checks
Invoke-DbcCheck -Check Instance
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset