In Adaptive Server version 12.5.3, use sp_configure to set the number of native threads and the wait time for messaging.
Summary information |
|
|---|---|
Default value |
50 |
Maximum values |
1000 |
Status |
Dynamic |
Display level |
Intermediate |
Required role |
System Administrator |
Use to define the maximum number of native threads the server spawns per engine. When the limit for the native threads is reached, Adaptive Server sessions that require a native thread, sleep until another session releases a native thread.
Summary information |
|
|---|---|
Default value |
50 seconds |
Maximum value |
4026531839 seconds |
Status |
Dynamic |
Display level |
Intermediate |
Required role |
System Administrator |
Use to define the time 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.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
