The Datafile SQL Monitor oversees the SQLMgr program checking for memory usage and time responses. The monitor checks on a set time period (configurable) and if a condition is triggered such as high memory usage or a considerable delay in updating a SQL table forces a reset of the SQLMGR and restarts the program and emails a restart warning to a nominated address.
Running the SQL Monitor program minimises the monitor to the tray. On initial set-up you will wish to set parameters so right-click on the tray icon and choose Options.
Parameter Settings allowed include:
Monitory Frequency - checks every X minutes for failure, can reduce this but don’t go below about 5 minutes.
SQLMgr Busy Allowance – when a SQL Update entry begins it starts a clock and resets on beginning of next entry. When the monitor checks the operation of the MGR if the clock has been going for more than this number of minutes a reset is forced. Leave this a reasonable amount of time as some database refreshes can take a while. 20-30 minutes would be usual.
SQLMgr Memory Allowance – number of megabytes system can use, if using more than this when monitor checks forces a restart. Set this reasonably high (500Mb recommended) as large database refreshes can use quite a bit of memory.
Restart SQLMgr – set to allow restart of the SQL Manager on error
Force Restart – set to force the close of the current session SQL Manager program on restart.
Auto Start SQL Mgr – set to allow SQL Monitor to auto start the SQL Manager
SMTP Host – enter the host address of your email client
User Name – enter the user id for the email client
Password – enter the password for the mail client
Email – enter email address of mail client and set to use SMTP protocol (otherwise uses default mail client options)
Run Params – if the Datafile system doesn’t use a DFWIN.INI but instead uses a shortcut with a path to the DATAFILE.INI enter the same path here.
Article ID: 1725
Created On: Thu, Jul 5, 2012 at 11:05 AM
Last Updated On: Mon, Jun 12, 2023 at 2:43 PM
Online URL: https://kb.datafile.co.uk/article/datafile-sql-monitor-1725.html