sproc optimize timeout limit

Summary information

Default value

40

Range of values

0 – 4000

Status

Dynamic

Display level

Comprehensive

Required role

System administrator

Configuration group

Query Tuning

sproc optimize timeout limit specifies the amount of time Adaptive Server can spend optimizing a stored procedure as a fraction of the estimated execution time.