Skip to main content
Version: 6.12

Mirroring Monitor Task

The Mirroring Monitor task is designed to monitor and report on the status of the mirroring connection between Patriot's primary and backup MS SQL server instances. The task will generate a system alarm if the mirroring connection ever exits the synchronised state. E.g. an alarm will generate if the backup server was to drop offline. The task reports all mirroring state and role changes to its System Account template. Warning and informational signals about the performance of the mirroring connections are likewise logged.

Requirements​

  • Enterprise level Patriot registration or the Enterprise Database module.
  • Database Mirroring must be enabled.

Task Setup​

System Menu Item > Tasks > Task Settings

Please read Task Settings for general information about adding tasks.

Add Task Add a new task to the list in the Task Settings window. Double click on Mirroring Monitor task in the drop down list in the details area of the window.

Next Click the next button to continue. The Mirroring Monitor task settings form will appear.

Mirroring task settings
The Mirroring Monitor task reports all errors, restores and informational events to the nominated System Account No (DBMM00101 by default).

Task Settings​

Uncommitted Log​

The maximum size that the unsent transaction log (on the principle server) or un-restored transaction log (on the mirror server) can grow to before a warning signal (System Type No. 65055) is logged. A supplementary warning signal of the same event type number will be logged at each multiple of this threshold. A restore signal of the same type number will logged when the uncommitted log restores to below this threshold. Under normal circumstances, when the mirroring state is synchronised, the uncommitted log should never grow above ~1 MB. If the mirroring connection is temporarily disconnected then you should expect the uncommitted log to grow indefinitely until either the synchronised state is restored or a transaction log backup is made (in which case mirroring must be re-enabled from a fresh restore point). The default value for this setting is 50 MB.

Average Transaction Delay​

The maximum level that the average delay per transaction caused by database mirroring can reach before a warning signal (System Type No. 65055) is logged. A supplementary warning signal of the same event type number will be logged at each multiple of this threshold. A restore signal of the same type number will logged when the average delay per transaction caused by database mirroring restores to below this threshold. The default value for this setting is 10 ms.