Accessing Activity Monitor Tables
The activity statistics are stored in these three tables. The three tables contain the data about the same activity, but using a different time period to aggregate the data. The three tables are:
-
Ens_Activity_Data.Seconds—aggregates activity over 10-second intervals.
-
Ens_Activity_Data.Hours—aggregates activity over 1-hour intervals.
-
Ens_Activity_Data.Days—aggregates activity over 1-day intervals.
This redundancy in storage provides the flexibility to minimize the long-term storage required for the statistics without losing the ability to examine historic data. For example, you can use the Ens_Activity_Data.Seconds table to closely examine activity over the previous two days but purge data after two days to minimize storage. The Ens_Activity_Data.Hours and Ens_Activity_Data.Days tables store less data and can be purged much less frequently. You can use the Ens_Activity_Data.Hours table to examine how activity changes over the course of a day. For example, you could use it to generate a report of the peak activity periods during each day of the week and the impact it has on delays and queue sizes.