Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AnimalMagic
Starting Member
28 Posts |
 Posted - 2007-10-03 : 06:27:14
|
| Hi All,I am trying to monitor the lock mode types held during various transactions and want to know if there is a way of doing this? I can run the transaction in QA with a begin tran and a sp_lock, then do a rollback, but the locks shown are just for that one time run through. I can monitor locks aquired/released in profiler but this doesnt show me (i dont think!) the lock mode. What im trying to find is what scenario a lock is being escalated to a table lock and locking out another process.Any feedback/advice would be great.ThanksJohn |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-03 : 23:07:30
|
| You can check that in em, but need keep refresh it. |
 |
|
|
AnimalMagic
Starting Member
28 Posts |
Posted - 2007-10-04 : 05:23:58
|
quote:
Originally posted by rmiao
You can check that in em, but need keep refresh it.
damn, i thought that would end up being the answer :( i was hoping there was a way i could capture the results in a script or something, or an option i was missing in profiler. Thanks anyway :) |
|
|
|
evilDBA
Posting Yak Master
155 Posts |
Posted - 2007-10-04 : 15:28:11
|
| I use one utility which really records locks and deadlocks (it monitors it constantly), and records DBCC INPUTBUFFER(..) of participating connectionshttp://www.sqlsolutions.com/products/sql-deadlock-detector/index.html |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-04 : 15:36:39
|
| AnimalMagic, if EM is doing what you want, then capture the commands that it issues by running a trace in SQL Profiler.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Monitoring Locks