Why do I occasionally see gaps in some of the charts in Performance Advisor?

On most occasions, I see these gaps in the memory counters. Please advise.

avatar image By pilotwave 16 asked Sep 25, 2012 at 02:27 PM
more ▼
(comments are locked)
10|5000 characters needed characters left

1 answer: sort voted first

The max allowed distance between data points on all dashboard charts is 90 seconds. This means that if two data points are farther apart than 90 seconds, a gap will be shown instead of drawing a line between the data points. This is because if we connect the points it can be misleading -- it may appear that the points on the line in between had values when in reality they didn't.

The reason this tends to show up more often for the memory counters is that they are only sampled every 60 seconds by default, while most other counters are collected every 10 or 20 seconds. So while we can miss several samples of other counters without showing a gap, if we only miss a single collection of the memory counters, the pre- and post- data points will be 120 seconds apart, and thus a gap will be shown.

Ultimately if the SQL Sentry Monitoring Service was running and we miss a sample, it means that load on the target and/or the network was too high, or some other problem prevented it from collecting counter data. In other words, it's indicative of a problem on the network or monitored target that needs to be investigated. Typically you will also receive some failsafe alerts (Error or Offline) when this happens, assuming those alerts are configured. It could be something as simple as the network went down temporarily, or the target server was rebooted.

You can often diagnose the root cause by looking at what was happening on the other charts immediately prior to the gap, since again most of the other counters are collected more frequently than memory. Or click the “Jump to Calendar” button so you can see the chronology of events during that time.

If you still aren’t sure what you are seeing, run the “Windows + SQL Server Performance” report for the range in question (be sure the range size is <=30 minutes so we have raw data), export it to Excel format and email it to us at support and we’ll take a look.

avatar image By Suril Jasani ♦ 676 answered Sep 25, 2012 at 02:30 PM
more ▼
(comments are locked)
10|5000 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 4.2 MB each and 8.4 MB total.