March 9, 2006 at 9:20 am
Hi All,
I have question on locks. I had set the Performance Counter : SQLServer:Locks(_Total) \ Lock Timeouts/sec. The values that I have got for 30 minutes out of a total of 24 hour run are very high. I have values for this counter as : 451,225,897,1056 etc, but other than this 30 minutes period the values are as : 1.000, 0.0001, etc....
Now, what I understand from SQL Locks is that SQL Server internally handles locks.
What does this counter SQLServer:Locks(_Total) \ Lock Timeouts/sec actually determine. ? After how much time, does it mark a transaction as timed out ? There is no values set in the application side or set lock_timeout is no where defined. It is left on the sql to determine the lockign procedure ?
What I really want to know is that after how much time SQL actually times out if it is not able to get a lock on the particular resource and how does SQL come to those values as I have got in my Perf Counters.
Any help isvery much appreciated.
Thanks -- Kishore
March 13, 2006 at 8:00 am
This was removed by the editor as SPAM
March 13, 2006 at 12:31 pm
Don't confuse these counters with sql server database locking - they're not really related, well not in the way many people think. There's a really good ms press book on performance tuning sql server, it's at work so can't remember exact title. I suggest you get the book.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply