Graph issues with monitoring has been switched off

If for some reason dbWatch Control Center has not been connected to a database instance running SQL Performance package for an extended time, you can get odd statistics errors in the graphs. It will look like a linear gradual increase in number. This is due to statistics being based on a ever-increasing value, and we take snapshots of this value to determine the changes in a period.

Note that the internal execution time graph here displays this problem.

If you right-click on the “Internal SQL statistics” table, you can choose to “Clean down periods” to recalculate this correctly.

After this cleaning, the graph will look more like this:

Where the data is modified to express that we have no values in this time period.


Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment