This section provides some overview information on each of the Tealeaf CX databases.
Tealeaf captures statistical information from these databases, which is available through the Portal.
System database
The system database is required for the configuration and operation of all Portal and Reporting capabilities. It contains all Tealeaf system information that is created through the configuration and use of Tealeaf.
It contains the following data specific to the customer environment:
- Tealeaf user information
- Dashboards definitions
- Scorecards definitions
- Report definitions
- System log information
- Event definitions, including step-based event definitions
Filegroups
| Filegroup | Description |
|---|---|
PRIMARY |
Contains SQL Server database-specific information, including temp space and data management inside the database. Does not contain any Tealeaf data. |
CONFIG |
System configuration information contains all Tealeaf system configuration information, user profiles, and report definitions. |
INDEX |
Contains indexes on all tables in the database. |
APP_LOGS |
Contains log tables for various components of the Tealeaf application. |
Sizing
This database is small, typically between 500 MB and 1 GB. It might experience some growth during normal operation because system logging data is written in to the database.
Reporting database
This database contains statistical information about traffic that is captured from monitored customer applications.
This information is collected from the canisters, aggregated, and stored for use in reporting.
Filegroups
| Filegroup | Description |
|---|---|
PRIMARY |
Contains SQL Server database-specific information, including temp space and data management inside the database. Does not contain any Tealeaf 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 top movers 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.
Statistics database
The statistics database contains performance information about the Tealeaf CX system itself. It is used to monitor the systems health and to aid in troubleshooting if an issue arises.
Filegroups
| Filegroup | Description |
|---|---|
PRIMARY |
No Tealeaf data. Used by MSSQL Server for temp space and data management inside the database. |
DATA |
Tealeaf system statistics data |
INDEX |
Indexes for the database |
LOG |
The database log |
Sizing
This database should remain fairly small. Statistics gathering may be turned off by the user, in which case this database should never grow. If statistics are being gathered, then the size of the database is determined by the length of time the data is kept before being trimmed.