SQL Server Performance Forum – Threads Archive

Locking Blocks

I found that Total Blocking Locks counter is missing in perfmon. Bit I found a counter called Lock blocks.
Are they same?? —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

---

In which object section you are looking?
http://sqlserver-qa.net/blogs/perft…mon-counters-using-a-tsql-query-aka-dmvs.aspx fyi using with TSQL or DMVs.
Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

---

yes even that says Total Block Locks are missing But follwoing link says abot that counter.
http://www.microsoft.com/technet/ar…merce/maintain/optimize/perfmgt.mspx?mfr=true
Just want to know whetther Total Block Locks and Lock Blocks are same counters
—————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

---

]]>