SQLWATCH is a SQL Server database with some agent jobs. Installing SQLWATCH means deploying the database and corresponding agent jobs. It must be installed on each monitored SQL Server instance.
The project has been developed in Visual Studio Data Tools and the base for deployments are Data Application Tier Packages (DacPac). You can install SQLWATCH in several ways.
During installation, the following objects will be created:
- SQLWATCH database (or SQLWATCH objects in the existing database is such option was selected)
- Extended Event Sessions (
- Agent Jobs (
dbatools support multi-server installation with a single command:
To install into SQLWATCH database (new database will be created):
Install-DbaSqlWatch -SqlInstance Server1, Server2, Server3 -Database SQLWATCH
To install into your existing “DBA_ADMIN” database:
Install-DbaSqlWatch -SqlInstance Server1, Server2, Server3 -Database DBA_ADMIN
Install-DbaSqlWatch -SqlInstance DevServer1 -Database SQLWATCH -PreRelease
Install-DbaSqlWatchwas designed for unattended multi-server installations. It will download the latest release and unpack it, including the Power BI dashboard, into its temporary directory.