question

way2sequel avatar image
way2sequel asked

Locktimeouts/sec high in Perfmon

Hi All, I have got the following numbers from one of my busiest QA SQL server,does these numbers indicate any problem,As far i know locktimeouts/sec>0 is low which means there isnt any issue but i am just curious to understand how to analyze the lock statistics from perfmon. ![alt text][1] [1]: /storage/temp/4035-locktimeouts.jpg Thank you, BT
locking
locktimeouts.jpg (11.9 KiB)
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

100K lock requests per sec seems abnormally high to me, however I wouldn't base any decisions just on that single metric. Are you having a high number of reads? That's only a single metric and to identify an issue it'll usually take a combination of things.
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.