Page created: 7 Dec 2020 |
Page updated: 12 May 2021
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
If it's not possible to determine what data will be important in the future, backing up all DBMS data is the safest approach.