Our Brands

Impact-Company-Logo-English Black-01-177x54

Welcome to the Schneider Electric Website

Welcome to our website.
		
How can we help you today?
This FAQ has been written for NEAL (North East Africa and Levant) region. If you are looking for information for another region, please select the correct country from the top-left dropdown in the page and 'Navigate to Browse FAQs' in the Support menu.
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

Schneider Electric Egypt and North East Africa

Attachment(s)
PME 8.2 - User Guide.pdf [2.18 MB]
PME 8.2 Design Guide.pdf [5.81 MB]
Explore more
Product:
Range:
Users group

Discuss this topic with experts

Visit our community and get advice from experts and peers on this topic and more
Explore more
Product:
Range:
  • Products Documentation
  • Software Downloads
  • Product Selector
  • Product Substitution and Replacement
  • Help and Contact Center
  • Find our Offices
  • Get a Quote
  • Where to buy
  • Schneider Electric Community
  • Careers
  • Company Profile
  • Report a misconduct
  • Accessibility
  • Newsroom
  • Investors
  • EcoStruxure
  • Job Search
  • Blog
  • Privacy Policy
  • Cookie Notice
  • Terms of use
  • Change your cookie settings