resource-pool-runtime-cap.md
Prevents runaway queries by setting the maximum time a query in the pool can execute. If a query exceeds this setting, it tries to cascade to a secondary pool:
RUNTIMECAP { 'interval' | NONE }
-
interval: Maximum wait time expressed in the following format: -
NONE(default): No time limit on queries running in this pool.To specify a value in days, provide an integer value. To provide a value less than one day, provide the interval in the format
hours:minutes:seconds. For example a value of1:30:00would equal 90 minutes.If the user or session also has a
RUNTIMECAP, the shorter limit applies.