cpu grace time, together with time slice, specifies the maximum amount of time that a user process can run without yielding the CPU before SAP ASE preempts it and terminates it with a timeslice error.
|
Summary Information |
|
|---|---|
|
Default value |
500 |
|
Range of values |
0–2147483647 |
|
Status |
Dynamic |
|
Display level |
Comprehensive |
|
Required role |
System administrator |
|
Configuration group |
SQL Server Administration |
The units for cpu grace time are time ticks, as defined by sql server clock tick length.
When a process exceeds cpu grace time SAP ASE “infects” it by removing the process from the internal queues. The process is killed, but SAP ASE is not affected. This prevents runaway processes from monopolizing the CPU. If any of your user processes become infected, you may be able to temporarily fix the problem by increasing the value of cpu grace time. However, be sure that the problem really is a process that takes more than the current value of cpu grace time to complete, rather than a runaway process.
Temporarily increasing the cpu grace time value is a workaround, not a permanent fix, since it may cause other complications. See Performance and Tuning Series: Basics > Using Engines and CPUs for a more detailed discussion of task scheduling.