rtm thread idle wait period

Summary information

Default value

600

Range of values

600 – 4026531839

Status

Dynamic

Display level

Intermediate

Required role

System administrator

Configuration groups

SQL Server Administration

rtm thread idle wait period defines the time, in seconds, a native thread used by Adaptive Server waits when it has no work to do. When the time set for a native thread is reached, the thread automatically fades out.