Gaps of hourly summarized historical metric data missing

Article:TECH160641  |  Created: 2011-05-23  |  Updated: 2012-07-21  |  Article URL http://www.symantec.com/docs/TECH160641
Article Type
Technical Solution


Issue



When viewing historical metric data for a resource in the Historical Performance Viewer, there are large gaps of missing data. These gaps reside within the hourly summarization time frame and align across all resources.

 


Error



The following error may be observed in SQL if the purging maintenance SQL stored procedures are being run manually:

Msg 8134, Level 16, State 1, Procedure spMonitor_HourlyMetricSummary, Line 5
Divide by zero error encountered.
The statement has been terminated.

 


Environment



  • Monitor Solution for Servers  7.1.7113
  • Monitor Solution for Servers SP5  7.0.8641

 


Cause



This behavior occurs if there's a calculation error when summarizing certain metric data. If the average calculation fails for one resource, it causes the entire summarization procedure to fail for all resources. As a result, the summarized metric data for that time frame is lost.

This is a known issue and has been submitted to development.

 


Solution



Please contact Symantec Enterprise Support if a fix is required for one of the above environments.

This issue is resolved in the 7.1 SP2 release of Monitor Solution for Servers.

 


Supplemental Materials

SourceETrack
Value2354682
Description

 "Divide by zero" error may occur during spMonitor_HourlyMetricSummary



Article URL http://www.symantec.com/docs/TECH160641


Terms of use for this information are found in Legal Notices