- Get Grafana
- Create Data Source
- SQL Permissions
- Import SQLWATCH Dashboards
- How to use SQLWATCH dashboards
Grafana dashboards are available since SQLWATCH 3.0. This blog post explains a little bit more about the switch to Grafana.
Grafana is a free and Open Source dashboarding solution that can be installed in many different ways. I would recommend you head over to Grafana.com to learn about how to install Grafana on your Operating System.
Once installed navigate to your Grafana instance and login with the credentials you have set during the installation. Please read more about the installation on the Grafana.com page as I will not be covering the installation steps in this documentation.
Navigate to Data Sources
Add new Data Source
Search for Microsoft SQL Server
Configure connection to your SQL Server instance. This could be the central repository or any instance hosting SQLWATCH database. Set the minimum time interval to 5 seconds.
Grafana user should be a
db_datareader on the SQLWATCH database.
To import SQLWATCH dashboards, navigate to Dashboards -> Manage
Create new folder called SQLWATCH. This is where all SQLWATCH dashboards will reside.
Then click on import and upload JSON file - the SQLWATCH dashboards are JSON files included in the release.