What is the recommended SQL live database size limit
Issue
A commonly asked question is, how much should be kept in the live database
Product Line
Power Monitoring Expert 8.2
Power Monitoring Expert 9.0
Power Monitoring Expert 2020
Power Monitoring Expert 2021
Power Monitoring Expert 2022
Power Monitoring Expert 2023
Power Monitoring Expert 2024
Environment
Power Monitoring Expert
Microsoft SQL
Cause
The answer depends on the user, on how much data he/she wants to keep and also knowing their server specification (hardware).
They need to keep in mind how the database's growth will affect the performance of the system based on what they have in the field and on the server.
To help better determine this information, 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 has 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 USA
Need help?
Product Selector
Quickly and easily find the right products and accessories for your applications.
Get a Quote
Start your sales inquiry online and an expert will connect with you.
Where to buy?
Easily find the nearest Schneider Electric distributor in your location.
Help Center
Find support resources for all your needs, in one place.