time slice

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.