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