To increase the SQL Timeout to provide better throughput by giving the SQL Server a longer time to process the purging of archived events, there are two Registry values that can be added to the Change Auditor registry hive:
SQL Command Timeout
Location: Registry
Version 6.5 and later Path: HKEY_LOCAL_MACHINE\SOFTWARE\Quest\ChangeAuditor
Value Name: SQLTimeout
Value Type: DWORD
Value: Default 30 seconds (decimal)
Value: Maximum time in seconds for SQL command to execute. Impacts most client and Coordinator queries.
Start with 300 seconds (decimal) and increase in 60 second increments until the messages cease to be recorded in the logs.
Bulk SQL Command Timeout
Location: Registry
Version 6.5 and later Path: HKEY_LOCAL_MACHINE\SOFTWARE\Quest\ChangeAuditor
Value Name: BulkSQLTimeout
Value Type: DWORD
Value: Default = 30 seconds (decimal)
Value: Maximum time in seconds for bulk SQL command to execute. This includes bulk insertion of SQL events from agents.
Note: This effects Coordinator event inserts and the CA Database Checker. Consider increasing this value if you have "SQL error: TIMEOUT on INSERT INTO dbo....warnings in the Coordinator.Service.exe.nptlog.
Start with 300 seconds (decimal) and increase in 60 second increments until the messages cease to be recorded in the logs.
There is also an SQL timeout value that can be set for the timeout used by the Archive command:
ArchiveSQLCommandTimeout
Location: Registry
Version 6.5 and later Path: HKEY_LOCAL_MACHINE\SOFTWARE\Quest\ChangeAuditor\Coordinator
Value Name: ArchiveSQLCommandTimeout
Value Type: DWORD
Value: Default = 120 (decimal)
Note: Start with 120 , if there is still an issue increase to 600
Please note: If you have a Change Auditor version prior to 6.9.5, any folder/registry paths referenced may contain a non-Quest branded path.
Quest does not provide support for problems that arise from improper modification of the registry. The Windows registry contains information critical to your computer and applications. Make sure you back up the registry before modifying it. For more information on the Windows Registry Editor and how to back up and restore it, refer to Microsoft Article ID 256986 “Description of the Microsoft Windows registry” at Microsoft Support (http://support.microsoft.com/default.aspx?kbid=256986)