OVNPM 1.5.2 - Performance Monitor User and Installation Guide

HP Performance Monitor Database Schema 40
6-2-3 Stat Data Tables
The Stat data tables contain the trend data information required for capacity planning and management
reporting. The Service Broker keeps close look on the Insight Data tables and as soon as the Data collection for a
particular summarization interval is completed it fires an event to its background summarization service. This
starts the insertion of the calculated stats into the Stat Data tables.
The following Stat tables are available in the database.
• FIVEMINUTESTAT: Contains five minute data
• HOURLYSTAT: Contains hourly data
• DAILYSTAT: Contains daily data
• WEEKLYSTAT: Contains weekly data
• MONTHLYSTAT: Contains monthly data
• YEARLYSTAT: Contains yearly data
Stat Table Schema
Column Name
Data Type
Description
instanceId
Integer
Specifies the instance id
MetricId
Integer
Specifies the Metric ID
Day
Varchar(50)
Specifies the day
minVal
Float
Specifies the minimum value for the calculated stat
avgVal
Float
Specifies the average value for the calculated stat.
maxVal
Float
Specifies the maximum value for the calculated stat.