monitoring locks

  • I am trying to monitor the lock usage on a stored procedure using SQL Profiler. However, the profiler doesn't tell me what type of lock is being issues (table, row, page, etc.) How can you find this information in the profiler?

  • One thing you can do is run sp_lock while your stored procedure is running. It gives you a time slice which may or may not be beneficial.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply