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.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.
System Menu Item→Tasks → Task Settings
Please read TASK SETTINGS for general information about adding tasks.
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.
Click the next button to continue. The Mirroring Monitor task settings form will appear.
The Mirroring Monitor task reports all errors, restores and informational events to the nominated System Account No (DBMM00101 by default).
Uncommited Log (MB) is the maximum size that the unsent transaction log (on the principle server) or unrestored 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 uncommited log restores to below this threshold. Under normal circumstances, when the mirroring state is synchronised, the uncommited log should never grow above ~1 MB. If the mirroring connection is temporarily disconnected then you should expect the uncommited log to grow indefinitely until either the sychronised 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 (ms) is 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.