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 |
|
bobmcclellan
Starting Member
46 Posts |
 Posted - 2010-12-09 : 12:31:13
|
| I have 1 table in one db locked somehow....I opened a new query in SSMS and identified the spid I was usingI ran a trace and filtered on my spidI ran an update against 1 row in the table.The profiler shows the update sql and then nothing more.The activity monitor shows Status = Suspended Wait Type = LCK_M_IX which I discovered simply tells me there is a lock in place.I do not see anything else in the activity monitor wherethe Command = Update, Delete or Insert.Any help is very much appreciated.thanks in advance,..bob |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-12-09 : 12:47:01
|
| Execute sp_who2 and see if/what is blocking.Also execute DBCC OPENTRAN() to see if there are any explicit transactions that haven't committed. |
 |
|
|
bobmcclellan
Starting Member
46 Posts |
Posted - 2010-12-09 : 13:25:41
|
| Thanks Russell, Somehow the lock dropped and the update went through.it took 24 minutes for the one row to update. Now it is instantaneous.Updates are working fine again. I just wish I knew what caused the problem. |
|
|
|
|
|
|
Profiler / Activity Monitor help needed