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, <maillists0(at)gmail(dot)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?
>