I have a 9.2 server that occasionally becomes CPU bound. Disk wait is nominal and there's no memory pressure. The workload is almost all reads and the cache hit rate is high.
For some one minute periods, my monitoring shows around 1.5k to 2k access share locks out of a total of 7.5 to 8k transactions. What's the best strategy for finding out if that is creating a bottleneck?
For some one minute periods, my monitoring shows around 1.5k to 2k access share locks out of a total of 7.5 to 8k transactions. What's the best strategy for finding out if that is creating a bottleneck?
