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 |
|
devteam
Starting Member
15 Posts |
 Posted - 2006-02-24 : 04:01:23
|
| Hi,i am using sql server 2000. while running my application, sometimes the row is locked..i have given my locking status result.. can u tell me which process is blocking other process... what is the reason...Resultspid --> 52 ( Blocked by 57) --> dbcc inputbuffer(52) --> select error_key,error_parent_key from errors where error_parent_key = 24478spid-->57 (Blocking) --> dbcc inputbuffer(57) --> select property_value from application_property where system_code='DEFCRTNAM' and relation_key=21234spid-->65 (Blocked by 52) --> dbcc inputbuffer(65) -->sp_prepexec;1spid-->70 (Blocked by 52) --> dbcc inputbuffer(70) -->sp_prepexec;1thanks |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2006-02-24 : 04:15:36
|
| you have a blocking chain of:57 blocks 5252 blocks 65 AND 70So 57 is your "culprit".What is the rest of the SQL in 57? Is it part of a transaction? On the evidence given, there doesn't seem to be a good reason for this block.If it continues, look at tracing the system to figure out what the "process 57" is doing.HTH*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
 |
|
|
|
|
|
which process is blocking