...
Improves performance of the Archive Management/Gap Detection Process.
Improves performance of resetting a publisher, both with and without a filter. Note: Will be more efficient if appropriate indexes exist on the tables. Run the manual update script to create missing indexes.
Improves overall publishing performance. Note: Will be more efficient if appropriate indexes exist on the tables. Run the manual update script to create missing indexes.
Adds three reports for verifying data and schema integrity.
The "Data Integrity Report" returns information regarding potential errors in the configuration
The "Frequent Alarm and Event Report" returns information regarding meters with alarms and events above a given quantity .
The "Database Schema Integrity Report" returns details about the production schema that does not match the installed ACM version such as missing or mismatched indexes and triggers.
Provides a script to create all expected but missing indexes on ACM tables.
Modifies the stored procedure that is responsible for deleting archive records to make it more efficient.
Modifies the meter historization process to run in a stored procedure instead of a trigger to prevent issues with replication and clustering.
Modifies the meter historization process to only keep unique meter FieldData
Addition of a tblDBVersionHistory table to keep track of changes and scripts run against the database outside of a normal release.
Connections
Base Connection
...