Parameter
dbs/mss/max_duration

Short text
maximal runtime for stored procedure executionmaximal runtime for stored procedure executions in millisecondsIf given value is greater than 0 and the execution of a storedprocedure exceeds this value, the recompilation of the storedprocedure is triggered.

Work area
Database

Parameter unit
Time (milliseconds)

Default value
0 (no maximum)

Limitation for os
Windows NTMicrosoft SQl Server 7.00 and higher

Valid_values
<(>><)>= 0