Summary information |
|
|---|---|
Default value |
20 |
Range of values |
1–2147483647 |
Status |
Dynamic |
Display level |
Intermediate |
Required role |
System administrator |
Configuration groups |
Memory Use, User Environment |
For Adaptive Servers running with multiple engines, user log cache spinlock ratio 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 specifies 1 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 Series: Monitoring Adaptive Server with sp_sysmon.
