Hit send on that one too soon. I see 6.5k access share locks out of 7.5k transactions.
On Tue, Nov 26, 2013 at 12:41 PM, <maillis...@gmail.com> wrote: > 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? >
