SQL Server Performance Monitor
SQLWATCH is decentralised, real to near-real time SQL Server Monitoring Solution. It is designed to provide comprehensive monitoring out of the box and to serve as a monitoring framework for your own projects or applications. It collects performance data in a local database with an option for centralised reporting for convenience.
Server Overview:
Detailed charts:
SQLWATCH uses SQL Agent Jobs to trigger data collection on a schedule which write results to a local database. For that reason each monitored SQL Server instance must have SQLWATCH deployed, however, the destination database can be an existing "dbatools" database, msdb or a dedicated SQLWATCH database. For performance reasons, it is advisable to deploy into a dedicated database as we're setting Read Committed Snapshot Isolation which will not be done if deployed to an existing database. The data can be consumed and analysed by the Power BI report.
Tested on the following SQL Server versions:
Although Docker and Linux work, the Windows-only WMI based disk utilisation collector will fail.
The easiest way to install SQLWATCH is to use dbatools:
Install-DbaSqlWatch -SqlInstance SQLSERVER1,SQLSERVER2,SQLSERVER3 -Database SQLWATCH
Alternatively, SQLWATCH can also be deployed manually from the included Dacpac either via command line using SqlPackage.exe:
SqlPackage.exe
/Action:Publish
/SourceFile:C:\Temp\SQLWATCH.dacpac
/TargetDatabaseName:SQLWATCH
/TargetServerName:YOURSQLSERVER
/p:RegisterDataTierApplication=True
Or by deploying Data-Tier application in SQL Server Management Studio