Grafana

---

• 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.

Get 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.

Create Data Source

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.

SQL Permissions

Grafana user should be a db_datareader on the SQLWATCH database.

Import SQLWATCH Dashboards

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.

How to use SQLWATCH dashboards

Coming soon…

---