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 (
During installation, once the Agent Jobs have been deployed, the following job will be automatically invoked:
SQLWATCH-INTERNAL-CONFIG. The job is normally scheduled to run every hour but the performance data collection will not start until this job runs. If the job fails to run during the deployment, you may want to run it manually after the deployment.
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.