Page created: 26 Jul 2021
|
Page updated: 14 Jan 2022
The PingDataMetrics Server stores all historical metric samples in the PostgreSQL DBMS, along with several other data tables that are used for bookkeeping and normalization of the sample data.
Even a small PingDataMetrics Server installation, which monitors three to four servers, will use sample tables that occupy 95% of the total DBMS space. While a functional backup must capture a consistent view of several tables, the size of the sample tables dictates the desired approach to a regular backup strategy.
The historical samples enable:
- Diagnosing past performance problems
- Capacity planning and historical reporting
- Access to data needed for a revenue stream, such as data used for billing and charge back
Note:
If it's not possible to determine what data will be important in the future, backing up all DBMS data is the safest approach.