Viewing Locking Activity with SQL Server Profiler

Another tool to help you monitor locking activity in SQL Server 2014 is SQL Server Profiler. SQL Server Profiler provides a number of lock events that you can capture in a trace. The trace information can be viewed in real-time or saved to a file or database table for further analysis at a later date. Saving the information to a table allows you to run different reports on the information to help in the analysis.


This chapter provides only a brief overview of how to capture and view locking information using SQL Server Profiler. For more information on the features and capabilities of SQL Server Profiler and how to use it, see Chapter 5, “SQL Server Profiler.”

SQL Profiler provides the ...

Get Microsoft SQL Server 2014 Unleashed now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.