sql server clock tick length

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.

In mixed-use applications with some CPU-bound tasks, decrease the value of sql server clock tick length to:

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.

Note: Changing the value of sql server clock tick length can have serious effects on SAP ASE performance. Consult with SAP Technical Support before resetting this value.