SQL Server中對各種鎖的介紹.

Introduction to Locking in SQL Server

http://www.sqlteam.com/article/introduction-to-locking-in-sql-server

 

SQL Server中還有一個叫做Latch的對象, SQL Server提供了一個performance counter來監視SQL Server內部的叫做latches的一種資源鎖. 通過監視latches可以確定使用者的activity和resource usage, 可以協助我們評鑑效能瓶頸.

 

下面是Latch的counters

• Average Latch Wait Time (ms)
• Latch Waits/sec
• Total Latch Wait Time (ms)

更多資訊, 參考

SQL Server: Latches Object

http://msdn.microsoft.com/en-us/library/aa905135%28SQL.80%29.aspx