Showing posts with label lock. Show all posts
Showing posts with label lock. Show all posts

Monday, March 12, 2012

Newbie Locking question

How many lock requests is too many? To explain, we have a customer who is
reporting some slow performance problems and he says that performance monito
r
is recording an average of 30 million lock requests and he thinks this is
excessive. So I guess my real question is, is he right, is this excessive?
I don't know much about SQL Locking so your patience is much appreciated.
Thank you for time,Drew
http://www.sql-server-performance.c...ucing_locks.asp
http://www.sql-server-performance.c...locks_hints.asp
"DrewV" <DrewV@.discussions.microsoft.com> wrote in message
news:95D799B0-A124-4566-A79E-FF5A4E637187@.microsoft.com...
> How many lock requests is too many? To explain, we have a customer who is
> reporting some slow performance problems and he says that performance
> monitor
> is recording an average of 30 million lock requests and he thinks this is
> excessive. So I guess my real question is, is he right, is this
> excessive?
> I don't know much about SQL Locking so your patience is much appreciated.
> Thank you for time,