The "Log to Database" action uses ADO to insert records into the specified database. By default ADO database commands will timeout after 30 seconds if the database is busy or does not respond.
If you see ADO command timeout errors in the error log, you may want to extend the timeout value. Because the database records are inserted in real time, a long timeout may cause message loss or delay the processing of other messages in the queue. Only extend this timeout if you are experiencing timeout errors.
Database Command Timeout
Section: HKEY_LOCAL_MACHINE\SOFTWARE\Kiwi Enterprises\Syslogd\Properties
Value (STRING): DBCommandTimeout
Min value: 0 (No timeout - not recommended)
Max value: 120
Default value: 30
Type: Timeout in seconds
By default, the database insert command will wait up to 30 seconds before returning a timeout condition. If your database is slow and needs more time to process the data in real-time, you can extend the timeout up to a maximum of 120 seconds. Setting the timeout value to 0 will cause the command to never timeout (this setting is not recommended as it can cause the program to fail if the database does not respond).