GWME-7.2.0-1 Grafana performance

Problem

This technical bulletin applies to GroundWork Monitor 7.2.0. The original "depth" of Grafana queries in the GroundWork data source are more extensive than actually necessary, which causes performance problems in selecting hosts and services in large datasets and in graphing large datasets over long periods. In extreme cases, the graph will not appear before a browser timeout (normally 60 seconds).

Solution

To address the problem above, we are providing a patch that reduces the depth of the queries to only return the data needed. This patch includes changes to configuration settings related to Grafana queries, and to the source files that make those queries. Applying it will not affect configured dashboards (other than to make them perform better), and will not otherwise affect monitoring or other processes on the system except for the interruption required while the system restarts.

Installation steps

Download the TB7.2.0-1.tar.gz below, and place in an accessible location on your GroundWork server.

Name	Size	Creator	Creation Date	Comment
TB-7.2.0-1.tar.gz	22.94 MB	Bren Eckles	Mar 14, 2018 13:11

Unzip the tarball:
```
tar zxvf TB7.2.0-1.tar.gz
```
This will create the sub-directory TB7.2.0-1.
Change to the TB7.2.0-1 directory:
```
cd TB7.2.0-1
```
As root user run install:
```
./TB7.2.0-1_install.sh
```

Uninstall rollback steps

As root user, in the Technical Bulletin directory (e.g., TB7.2.0-1) run uninstall:
```
./TB7.2.0-1_uninstall.sh
```