Link Search Menu Expand Document

Grafana


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.

Grafana Login Page

Create Data Source

Navigate to Data Sources

Grafana Configuration

Add new Data Source

Grafana Configuration

Search for Microsoft SQL Server

Grafana Configuration

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 Configuration

SQL Permissions

Grafana user should be a db_datareader on the SQLWATCH database.

Import SQLWATCH Dashboards

To import SQLWATCH dashboards, navigate to Dashboards -> Manage

Grafana Configuration

Create new folder called SQLWATCH. This is where all SQLWATCH dashboards will reside.

Grafana Configuration

Then click on import and upload JSON file - the SQLWATCH dashboards are JSON files included in the release.

Grafana Configuration

Grafana Configuration

How to use SQLWATCH dashboards

Coming soon…