Viewing Locking Activity with SQL Server Profiler
Another tool to help you monitor locking activity in SQL Server 2008 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.
Note
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 6, “SQL Server Profiler.”
SQL Profiler provides the ...
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
