To monitor the performance of a system, you need to keep track of locking activity in SQL Server. The following are the most commonly used methods to do so:
sys.dm_tran_locks dynamic management view directly
Viewing locking activity with SQL Server Profiler
Monitoring locks with Performance Monitor
As you read through the rest of this chapter, you might want to examine or monitor the locking activity ...