Introduction

As you already know, by using GreenLight you are able to create different kind of charts based on your interest. Basically there is no limitation on how many statistical data you add into one chart definition.
In these days however the majority of Charts are depicting only one or two statistical values over time (often depicted with several servers). In order to get a much better picture a combination of different statistics
is essential. So one of the main questions is what kind of data you should combine in one chart to get a better understanding of what is going on in your environment.

In the example below we give you an idea how easy you can draw a graph for the following scenario:

We want to see over time how long it takes to access the public address book, to open the People View and to open a randomized document within this view. So we would like to have a kind of a access timetable.

 

Example

Configuration

Create a DB Access sensor

Before we can create a chart, we need to have a sensor in place.

In this example we create a simple Domino DB Access sensor definition where the sensor should open a random document within the People View of the names.nsf. 

 

Depending on the schedule definition, this Sensor collects different information.

 

Check the data and statistical values

To get an idea what sort of statistics this sensor collects, just do the following:

- Double click on one of the target servers (which you have selected in the DB Access sensor) on the health grid dashboard.

- Now click on Open Sensor Details

 

- Just select the name of the DB Access Sensor you have created before. Now you get all statistically values displayed on the right hand side

By expanding the “Tree” you see the statistic name as well the values form the last successful measurement.

 

However if you use the Search Filter (for instance enter the word “time”) you get all statistics regarding timing (excluding all the other statistics).

 

As said, you can now take this information for creating your own charts.

 

Create a Chart

Just create a line chart and select the following three statistics. You can find them easier if you enter “time.to_”  within the search field.

 

-Click Next

-Make sure you leave the Ascending Value Filter disabled.

 

-Make sure to add the correct Target as well to specify a schedule and a name for this charting definition.

 

-Whenever you have done this, just generate the chart.

 

In that example the initial picture gives you three different Y-axes (because of three different statistics). This is not ideal because we want to see how much time it took to access the database, to open the view and to access a random document. So we need to specify only one common Y-axis.

To do so, just click on the Axis Options (left top corner) and choose Apply largest axis maximum to all other axes.

 

Now all three lines are using one common Y-Axis.

BEFORE:                                                                                                   AFTER:

                           

 

Whenever you click on Legend you can adjust colors and other properties according to your needs.

 

Conclusion

With the generated chart you see at the very beginning that it took around 50ms to open the database, further 80ms to open the People view and additional 10ms to open a random document. In total it took ~140ms to do all three steps.

Over the time you may see peaks which correlate with the server load. Therefore the DB Access Sensor simulates an end-user and provides important information’s about your server performance. (Note: Combine these values with the Update.PendingList Statistic)