Reporting database

This database contains statistical information about traffic that is captured from monitored customer applications.

This information is collected from the Discover canister(s), aggregated, and stored for use in reporting.

Note: All tables containing indexes are stored in the Reporting database, which enables accurate "point in time" snapshots to be made by performing a backup of this single database.

Filegroups

Filegroup
Description
PRIMARY
Contains SQL Server database-specific information, including temp space and data management inside the database. Does not contain any Discover data.
DATA
Contains miscellaneous short-term lookup data
CANDATA
Contains the unaggregated data that is collected from the Processing servers
AGGDATA
Contains hourly aggregated event reporting data
AGGINDEX
Contains indexes for the tables in the AGGDATA filegroup
AGGDATALT
Contains daily aggregated event reporting data
AGGINDEXLT
Contains indexes for the tables in the AGGDATALT filegroup
AGGKEY
Contains the dimension report group key information that is used to aggregate dimension data
AGGKEYINDEX
Contains the indexes on the tables in AGGKEY
DIMVALUES
Contains tables that hold all dimension values used in reporting
DIMINDEX
Contains the indexes for the tables in DIMVALUES
EVENTDATA
Contains scorecard and anomaly detection data
EVENTINDEX
Contains the indexes for tables in EVENTDATA
PERFDATA
Contains all hourly Performance reporting data
PERFINDEX
The indexes for the data in PERFDATA
PERFDATALT
Contains all daily Performance reporting data
PERFINDEXLT
The indexes for the data in PERFDATALT

Sizing

The reporting database can be large. Its size is determined by the amount of traffic that flows through the website and the length of time for which you want to retain the reporting data.