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” and Chapter 4, “Using Engines and CPUs” in the Performance and Tuning: Basics 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.
