SqlWatch

Install-DbaSqlWatch

Ken K (github.com/koglerk)

Install-DbaSqlWatch View Source Ken K (github.com/koglerk) Windows, Linux, macOS Synopsis Installs or updates SqlWatch monitoring solution on SQL Server instances. Description Deploys SqlWatch, an open-source SQL Server monitoring and performance collection tool, to one or more SQL Server instances. SqlWatch continuously gathers performance metrics, wait statistics, and system information into dedicated tables for historical analysis and alerting. This function automatically downloads the latest SqlWatch release from GitHub (or uses a local file), then deploys it to the specified database using DACPAC technology.

Uninstall-DbaSqlWatch

Ken K (github.com/koglerk)

Uninstall-DbaSqlWatch View Source Ken K (github.com/koglerk) Windows, Linux, macOS Synopsis Completely removes SqlWatch monitoring solution from a SQL Server instance Description Performs a complete uninstallation of the SqlWatch performance monitoring solution by removing all associated database objects, SQL Agent jobs, and historical data. This includes dropping all SqlWatch tables (containing performance metrics history), views, stored procedures, functions, Extended Events sessions, Service Broker components, assemblies, and user-defined table types. The function also unpublishes the SqlWatch DACPAC registration to ensure clean removal.