The SQLMGR program, once started, reads the SQLDET database continually for new records to process and can mean – when your business operates on a set opening times basis – that the SQLMGR is interrogating the database when no changes are being made.
New options are
now available that can be added to the PARAM.INI (a file held within the main
Datafile SQL program folder which can be edited with any text editor) to
exclude mirroring during set days/times.
Commands to add are:
exclude=19:30-08:30
exclude_day=Sat,Sun
If you have a night time process that you need to mirror then you can set multiple times for exclusion, for example, you have an offsite import that is processed at midnight then you could have an ‘exclude’ entry along the lines of:
Exclude=19:30-23:30,01:00-08:30
Article ID: 1935
Created On: Fri, Oct 26, 2012 at 12:08 PM
Last Updated On: Mon, Jun 12, 2023 at 2:42 PM
Online URL: https://kb.datafile.co.uk/article/suspend-sql-mirroring-during-night-weekends-1935.html