Power Monitoring Expert(SPM/PME): How to configure the Database Size Notification task

Hvordan kan vi hjælpe dig i dag?

Issue
PME installations that use SQL Server Express will include a Windows Scheduled Task named [ION_Data] - SIZE NOTIFICATION - Job. This task monitors the size of the database in order to alert the users when the ION_Data database is reaching the 10 Gb size limit enforced by SQL Express. The task is configured with default values, this article shows what those values are and how to change them.

Product Line
Struxureware Power Monitoring Expert 7.0.x
Power Monitoring Expert 7.2.x
Power Monitoring Expert 8.x
Power Monitoring Expert 9.x
Power Monitoring Expert 2020
Power Monitoring Expert 2021
Power Monitoring Expert 2022
Power Monitoring Expert 2023

Environment

Scheduled Tasks

Resolution
The [ION_Data] - SIZE NOTIFICATION - Job uses a configuration file to store settings. This file can be found here:
<SPM/PME_Installation_Folder>\config\cfg\DbScheduledTasks\Support\Configuration.ps1

The Configuration.ps1 file contains the following settings and default values:
Name: locationForBackupFiles
Default setting: cfg\DBBackups\
Description: Contains the location where the backup file (.bak file) will be saved.

locationForBackupFiles

Name: maximumDatabaseSizeInGigabytes
Default setting: 9 (this is in gigabytes)
Description: The following setting specifies the largest size that a database is allowed to be on a system.

Name: databaseSizeNotificationThresholdPercentage
Default setting: 85
Description: The following setting defines the threshold for when a database size notification message will be issued. For example, setting the value to 75 means that the message will be issued when the database reaches 75% of the maximum database size allowed (the maximumDatabaseSizeInGigabytes setting mentioned above).
The way the task uses these values is by measuring the current size of the ION_Data database, and comparing this size to a percentage relative to the maximum database size set in the maximumDatabaseSizeInGigabytes setting. If this percentage is equal to or higher than the value of the databaseSizeNotificationThresholdPercentage setting, a message will be logged to the System Log that can be seen in the Active Alarm Viewer and the Event Log in Vista.

The configuration values can be changed to serve specific notification purposes, for example if you want to be alerted of the database size earlier than the 85% of 9GB (this default was chosen to allow enough time to take preventive action).

Important Note: These are the ranges allowed for the following configuration values. Entering values outside of this ranges will cause the task to malfunction and result in notification failures:

Setting: maximumDatabaseSizeInGigabytes
Range: 0 - 10 (based on the maximum database size enforced by SQL Express)

Setting: databaseSizeNotificationThresholdPercentage
Range: 0 - 100

Additional Information
Transaction Log File: The size of the ldf file is not taken into consideration for the maximum database size enforced by SQL Express. Only the mdf file size is used in the calculations.

For instructions on how to disable the Database Size Notification completely please follow the steps provided in FA383305: Your database_name database is x% full" warning is shown in Management Console | Schneider Electric USA