GWME-7.2.0-1 Grafana performance

h5. 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).

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

h5. Installation steps

# Download the {{TB7.2.0-1.tar.gz}} below, and place in an accessible location on your GroundWork server.
{attachments:^TB7.2.0-1.tar.gz}
# Unzip the tarball:
{noformat}
tar zxvf TB7.2.0-1.tar.gz
{noformat}
This will create the sub-directory TB7.2.0-1.
# Change to the TB7.2.0-1 directory:
{noformat}
cd TB7.2.0-1
{noformat}
# As {{root}} user run install:
{noformat}
./TB7.2.0-1_install.sh
{noformat}

h5. Uninstall rollback steps

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