Summary information |
|
|---|---|
Default value |
100 |
Range of values |
50–1000 |
Status |
Dynamic |
Display level |
Comprehensive |
Required role |
System Administrator |
time slice sets the number of milliseconds that Adaptive Server’s scheduler allows a task to run. If time slice is set too low, Adaptive Server may spend too much time switching between tasks, which increases response time. If it is set too high, CPU-intensive tasks might monopolize engines, which also increases response time. The default value, 100 milliseconds, allows each task to run for 1/10 of a second before relinquishing the CPU to another task.
See “cpu grace time”. Also, see Chapter 3, “Using Engines and CPUs,” and “Execution task scheduling” on page 29 in the Performance and Tuning Guide for a more detailed discussion of task scheduling.
Use sp_sysmon to determine how time slice affects voluntary yields by Adaptive Server engines. See the Performance and Tuning Guide for more information.
