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,
No comments:
Post a Comment