Enforce Maximum Timeouts for SQL Timeouts

This Optional Feature, Enforce Maximum Timeouts for SQL Timeouts, when enabled, enforces maximum timeouts for SQL queries, updates and procedure calls. While SQL queries, updates and procedure call timeouts can be controlled with existing properties, this optional feature, when enabled, applies an upper bound to the timeouts to avoid system instability due to long-running queries or updates.

Staged Timeout Limits

Query

• UI, Sql Servlet 15 min
• Data Replication 5 min
• Agents 30 min
• Everything else 10 minutes

Updates

• 15 minutes with the exception of Classification Index Builder (GTM), which is 30 minutes

Procedures

• Direct SQL 5 min
• SQL Servlet 4 min 45 sec
• Everything else 10 minutes

Business Benefit

This feature helps avoid system instability due to long-running queries or updates.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

The Maximum Timeouts Limits are to help prevent performance issues caused by slow SQL.  While you cannot set Timeout Limits higher than the Maximum Timeouts  - you have the option of setting lower limits.