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 |
|
SQL360
Starting Member
20 Posts |
 Posted - 2008-09-16 : 19:04:41
|
| If you can shed some light on what do I need to be digging for to possibly find problem relating to blocked by and blocking.Current ScenarioUnder locks/process idthere is spid 12 (blocked by 12)and right below there is spid 12 (blocking)I can see on which db this blocking is happenning but what else would you look for to see if there is any possible problem happenning.when I go to properties for different types of lock type within that spid, it says Last TSQL command batch: sp_unprepare;1Thank you in advance for help.SQL360 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
SQL360
Starting Member
20 Posts |
Posted - 2008-09-16 : 21:55:40
|
Thank you. In what possible scenarios the same spid block itself?Could it be during mutiple insert/update in the same table?SQL360 |
 |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2008-09-16 : 23:09:16
|
| http://support.microsoft.com/kb/906344/en-usBe One with the OptimizerTG |
|
|
|
SQL360
Starting Member
20 Posts |
Posted - 2008-09-18 : 00:42:26
|
| Thank you for the linkSQL360 |
|
|
|
|
|
|
Blocking and Blocked by