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.