K
Keith Sudbury
Guest
Tuning spin for varying workloads is a bit of "magic". Take care that your new setting doesn't cause excessive CPU consumption during your normal workload. There are a lot of cases where the latch timeouts can actually be resolved in other/better ways than just increasing -spin. Take a look at the Latch Counts (debghb - 11) and take a look/post which latches you are having issues with.
Continue reading...
Continue reading...