15_-_Database_Maintenance_Configuration.pdf

Database Maintenance EcoStruxureTM Power Monitoring Expert Digital Power Global Training Confidential Property of Schneider Electric Internal  Your Database needs Special Care Confidential Property of Schneider Electric | Page 2...

Database Maintenance EcoStruxureTM Power Monitoring Expert Digital Power Global Training Confidential Property of Schneider Electric Internal  Your Database needs Special Care Confidential Property of Schneider Electric | Page 2 Internal Chapter Objective: By the end of this chapter, you will be able to understand: 1. Configure and schedule your database operations. 2. Know about backup, maintenance and trimming of your database. Internal  Agenda 01 02 03 04 Maintenance Database Manager Windows Task Key Points to Overview Scheduler Remember Internal Maintenance Overview Database Maintenance PME uses databases to store information such as system configuration, data logs, and system event log messages. Databases must be maintained to preserve performance, manage disk space use, and guard against data loss in case of database failure. Confidential Property of Schneider Electric | Page 6 Internal What is Database Maintenance? Keep the database operating at an optimal level of performance. There are two methods used for database Over time, a database may become large and slow if it maintenance: is not regularly de-fragmented, trimmed and optimized. Use Database Manager to manually perform maintenance operations on the Power Monitoring Expert databases. Database backups are important "snapshots" of the database Use Windows Task Scheduler to configure Recoverable points in time, in the event that the scheduled jobs to perform automated database fails (for example, server crashes, custom operations such as backup, maintenance, SQL scripts, and so on) and trim. Confidential Property of Schneider Electric | Page 7 Internal Database Manager Management Console Confidential Property of Schneider Electric | Page 8 Internal Database Manager Management Console > Tools > Database Manager Use Database Manager to manually perform operations on the PME databases. Archive Export Registry Settings New ION_Data Database Trim Upgrade Database Prerequisites: User needs to be a member of the sysadmin SQL Server role, which is set in SQL Server Management Studio. A. SQL Server Instance C. Options menu B. Databases D. Show Archives Confidential Property of Schneider Electric | Page 9 Internal Windows Task Scheduler Windows Build-in Feature Confidential Property of Schneider Electric | Page 10 Internal Windows Task Scheduler Configure scheduled jobs to perform operations such as backup, maintenance, and trim Database Scheduled Job Default Time Database tasks are preconfigured (standalone system only) and Backup Daily at 1:30 AM Application Modules enabled by default. Maintenance Daily at 3:30 AM (Application_Modules) Trim Daily at 2:30 AM Configured or disabled using the Window Task Scheduler. Archive (disabled by default)* Annually, on Jan 3 at 1:00 AM Backup Weekly, Friday at 12:00 AM ION database (ION_Data) Maintenance Daily at 2:00 AM Prerequisites: Size Notification (SQL Express)** Daily at 3:00 AM Backup Daily at 1:00 AM Password for the IONMaintenance Network Configuration database (ION_Network) Maintenance Daily at 7:30 AM account before you can perform any Task Scheduler actions. System Events database Trim Daily at 4:00 AM (ION_SystemLog) Maintenance Daily at 7:05 AM * The PME archive task does not trim the database, it only copies data to the archive. ** Size Notification is only used for systems with SQL Server Express. Confidential Property of Schneider Electric | Page 11 Internal RECAP Internal  Key Points to Remember Database maintenance is the process of executing manual and automated tasks on a database to keep it operating at an optimal level of performance. Database Manager helps users maintain the information contained the databases through periodic maintenance, backups and archives. The default scheduled jobs are best for most applications unless specifically required to change or update. Confidential Property of Schneider Electric | Page 13 Internal © 2021 Schneider Electric. All Rights Reserved. Schneider Electric and Life Is On Schneider Electric are trademarks and the property of Schneider Electric, its subsidiaries, and affiliated companies. Internal