Comparing Data Sets Using Sightline EDM

Using Sightline EDM, there are multiple methods available to compare two or more sets of data. In this example, we’re using the data from test systems in the Sightline office, but the data sets could come from any system type.

The first and easiest option is to simply display data in a chart. When data has the same time stamps but is from two different systems or data sources, you can include them on the same chart. In this example, you can see CPU and memory utilization from a Windows system called newpetronas (NEW) along with CPU and memory utilization from a Linux system called phoenix.

1110_a

For any chart within EDM, you can request the statistics view, which shows the minimum, maximum and average values from the chart, as well as the standard deviation. This will be displayed as a separate window from your browser.
1110_b

Sightline also offers options for disparate time spans. In the event that you want to compare, say, a Monday with the following Monday, you could create charts side-by-side showing the same metric from the two different time spans, shown below.
1110_c

In this case, the data is from newpetronas in both charts, but utilization statistics from Monday, October 27 are shown on the left, with the same metrics from Monday, November 3 on the right. The statistics view can be generated from any chart in any display.

This view supports data from multiple systems in the charts, as well as different times. For instance, the Sightline workload is comprised of several processes (for data collection, storage and transfer to one or more instances of EDM) used by the Power Agent. In this view, you can compare the utilization on newpetronas on the left to phoenix on the right.
1110_d

Finally, Sightline offers a zoom chart capability. In this case, the basic chart covers a longer time span, but you can highlight a time span and move it to superimpose it over a different time. Consider this example:

1110_e

The time span of the chart covers five days, Monday through Friday. In the zoom chart, we can highlight the data from Monday and “move” it to overlay a 24 hour span for Thursday. Monday’s data is shown in dotted lines on the gray background; you can see that the shape of the lines are the same as the original data at the left of the chart. Using the zoom chart, you can also zoom in to display more granular data for the selected time range.

Ask John

Questions? Comments? Suggestions? Ask John! If we use your input in a future newsletter, we’ll send you a $10 Amazon gift card.