PowerQuality Infrastructure Workspace

PowerQuality Infrastructure Toolbar

Item

Name

Description

Drop

Delete an existing PowerQuality Database.

Purge

Deletes the data from PowerQuality Database. This function typically is used once following project commissioning.

Save

Save the data when:
– Creating a project
– Upgrading a project

Backup

Back up an PowerQuality Databse to an PowerQuality Database backup file.

Edit

Edit an existing PowerQuality Database.

Upgrade

Upgrade the PowerQuality Database to a new version.

Statistics

Display the memory used by the individual data group.

Name

Description

DB status

Displays the status of the PowerQuality Database:
Current: The database is up to date.
Outdated: The database needs to be upgraded.

DB name

Name of the PowerQuality Database in the project. The following characters are not permitted: /, \, :, *, ?, “, <, >, |, #, @, [, ], {, }, $, !, &, %, +, -, &, (, ), ‘, ~, ;, ,, ., space.

Database size

Determines the size of the PowerQuality Database (1 to 250 GB). Default is 10 GB:
– Maximum 10 GB on SQL Server Express
– Maximum 250 GB on SQL Server Enterprise

Recovery model

Defines the recovery model used for the PowerQuality database (simple or full) (see Recovery Models). You can change the backup model at any time.

Creation date

Displays date and time when PowerQuality database was created.

SQL Server version

Displays the currently installed SQL Server version operating with the PowerQuality database.

Original SQL Server

Displays the service and NamedInstance name applied to the PowerQuality Database.

Version

Displays the present version of the PowerQuality database.

SQL Server

Displays the name of the NamedInstance of the SQL Server containing the PowerQuality database.

T-Log size

Displays the size of the transaction log file. The transaction log file is always twice as large as the PowerQuality Database.
This size is required to ensure no loss of data during database reorganizations.
This allows for performant database reorganizations under load and limits the overall database size.

Last restore date/time

Displays the date and time of the last restore of the PowerQuality Database.

Created by

Displays who created the PowerQuality Database.

Original SQL Server version

Displays the original version of the SQL Server used to create the PowerQuality Database.

Name

Description

Data file

Folder and file name of data file

Log file

Folder and file name of the transaction log file

Backup file

Folder and file name of the PowerQuality database backup file

Recovery log path

Automatically created backup file is stored at this path. This file can be used to recover the PowerQuality database.

Name

Account

Description

DB Owner

<user defined>

Desigo CC SMC user who requires PowerQuality database owner rights. You can change it as required by stopping and editing database. The PowerQuality database owner must be different than the PowerQuality database user and the PowerQuality database service user.

DB user

System

Desigo CC project user who requires PowerQuality database user rights for read and write operations. You can change it as required in SMC > System > Management tab > Settings expander > System Account Settings, assign required user in system account. For more information, refer System Account Settings.

DB service user

PowerQuality Database service

Desigo CC service user who requires PowerQuality database service user rights for maintenance operations. You can change it as required in SMC > System > Management tab > Services expander > Siemens GMS PQDB Service > Service Account, assign required user for service account. For more information, refer Services Expander.

Name

Description

Running task

Displays the currently operating, automated tasks as well as tasks initiated from the System Management Console, for example Backup. The date of the last action is displayed to the right.

SMC task

Displays the tasks started on the System Management Console, for example, Backup. The date of the last action is displayed to the right.

SMC task state

Displays the state of tasks to be run:

• Planned
• Running
• Successful

Purge

• Data deletion.
• Purge can be manually triggered, and also automatically triggers when PowerQuality database is filled 70%, and 90%.

Database Full Warning 50%

• Once the data reaches 50% a message appears in the Task Info Expander.

Database Full Critical 70%

• Once the data reaches 70%, Database Full 70%-Critical message shown in task info expander. Purge will start, and 10% of the oldest data will be deleted recursively till it reaches below 70%.
• An alarms will be shown in status section named PowerQuality Database is 70% filled. This alarm will appear and remain until database is below 70%.

Database Full Emergency 90%

• Once the data reaches 90%, Database Full 90%-Emergency message shown in task info expander. Purge will start, and 30% of the oldest data will be deleted.
• An alarms will be shown in status section named PowerQuality Database is 90% filled. This alarm will appear and remain until database is below 70%.