time slice sets the number of milliseconds that the SAP ASE scheduler allows a task to run.
|
Summary Information |
|
|---|---|
|
Default value |
100 |
|
Range of values |
50–1000 |
|
Status |
Dynamic |
|
Display level |
Comprehensive |
|
Required role |
System administrator |
|
Configuration group |
SQL Server Administration |
If time slice is set too low, SAP ASE may spend too much time switching between tasks, which increases response time. If it is set too high, CPU-intensive tasks may monopolize engines, which also increases response time. The default value allows each task to run for 1/10 of a second before relinquishing the CPU to another task.
See Performance and Tuning Series: Basics > Using Engines and CPUs.
Use sp_sysmon to determine how time slice affects voluntary yields by SAP ASE engines. See the Performance and Tuning Series: Monitoring SAP Adaptive Server with sp_sysmon.