Issue
A commonly asked question is, how much should be kept in the live data base
Product Line
Power Monitoring Expert
Environment
Power Monitoring Expert
Microsoft SQL
Cause
It really depends on the customer, on how much data he/she wants to keep and also knowing their server specification (hardware).
They need to keep in mind how to the database's growth will affects the performance of the system based on what they have.
To help better determine this use the following documentation linked below:
Resolution
Power Monitoring Expert Database Growth Calculator
Database Growth Calculation formula
Database Maintenance Recommendations
Once the amount of live data have been decided use the following articles to help with database archiving, trimming, and maintenance
How to trim the PME database
How to set up recurring trims on the PME databases
A commonly asked question is, how much should be kept in the live data base
Product Line
Power Monitoring Expert
Environment
Power Monitoring Expert
Microsoft SQL
Cause
It really depends on the customer, on how much data he/she wants to keep and also knowing their server specification (hardware).
They need to keep in mind how to the database's growth will affects the performance of the system based on what they have.
To help better determine this use the following documentation linked below:
Resolution
Power Monitoring Expert Database Growth Calculator
Database Growth Calculation formula
Database Maintenance Recommendations
Once the amount of live data have been decided use the following articles to help with database archiving, trimming, and maintenance
How to trim the PME database
How to set up recurring trims on the PME databases
Released for:Schneider Electric Nigeria
