sbendayan
SSCommitted
Points: 1791
More actions
April 29, 2002 at 12:36 pm
#105319
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?
cjlane
SSC Eights!
Points: 878
April 29, 2002 at 3:04 pm
#428055
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