Lock Timeouts/sec Performance Counter

• Wayne-153714

  Hall of Fame

  Points: 3536

  More actions

  December 22, 2004 at 9:22 am

  #162089

  When our web site is busy, we have a high number of 'lock timeouts/sec', when monitoring via Perfmon.

  Does this mean that someone is getting an actual timeout message on a page, or does it mean that locks are escalating?

  My documentation says we should have timeout of zero, is this realistic?

  How do I find out what spids and queries are causing the timeouts?

  ---

  When in doubt - test, test, test!

  Wayne
  

• December 27, 2004 at 8:00 am

  This was removed by the editor as SPAM

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  December 28, 2004 at 1:26 pm

  #535188

  I don't think users are getting any page timeouts.  THere are a couple of ways to see what is causing the lock timeouts:

  1. If you get lucky you can see a process that is causing a lock/block issue by running sp_who or sp_who2 then running DBCC INPUTBUFFER(spid) to see the query that is causing the problem.
  2. Run a Trace on the server using SQL Profiler.  There is an event group for locks that will show the various lock events.

  There are also 3rd Party tools from people like Idera that monitor and store information regardning these issues.

  Hope this was of help.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question