sql server clock tick length specifies the duration of the server’s clock tick, in microseconds.
|
Summary Information |
|
|---|---|
|
Default value |
Platform-specific |
|
Range of values |
Platform-specific minimum–1000000, in multiples of default value |
|
Status |
Static |
|
Display level |
Comprehensive |
|
Required role |
System administrator |
|
Configuration group |
SQL Server Administration |
Both the default value and the minimum value are platform-specific. SAP ASE rounds values up to an even multiple of n, where n is the platform-specific clock-tick default value. Use sp_helpconfig or sp_configure to find the current values for sql server clock tick length.
Help I/O-bound tasks – a value of 20,000 is reasonable for this. Shortening the clock-tick length means that CPU-bound tasks exceed the allotted time on the engine more frequently per unit of time, which allows other tasks greater access to the CPU
Marginally increase response times – SAP ASE runs its service tasks once per clock tick. Decreasing the clock-tick length means that the service tasks are run more frequently per unit of time
Increasing sql server clock tick length favors CPU-bound tasks, because they execute longer between context switches. The maximum value of 1,000,000 may be appropriate for primarily CPU-bound applications. However, any I/O-bound tasks may suffer as a result. You can mitigate this somewhat by tuning cpu grace time.