Summary information |
|
|---|---|
Default value |
20 |
Range of values |
1–2147483647 |
Status |
Dynamic |
Display level |
Intermediate |
Required role |
System Administrator |
For Adaptive Servers running with multiple engines, the user log cache spinlock ratio parameter specifies the ratio of user log caches per user log cache spinlock. There is one user log cache for each configured user connection.
The default value for this parameter is 20, or one spinlock for each 20 user connections configured for your server.
Use sp_sysmon to understand how this parameter affects cache behavior. See the Performance and Tuning Guide for more information.
For more information about configuring spinlock ratios, see “Configuring spinlock ratio parameters”.
