SQL Server Performance Forum – Threads Archive

Which process is blocking

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… Result
spid –> 52 ( Blocked by 57) –> dbcc inputbuffer(52) –> select error_key,error_parent_key from errors where error_parent_key = 24478 spid–>57 (Blocking) –> dbcc inputbuffer(57) –> select property_value from application_property where system_code=’DEFCRTNAM’ and relation_key=21234 spid–>65 (Blocked by 52) –> dbcc inputbuffer(65) –>sp_prepexec;1 spid–>70 (Blocked by 52) –> dbcc inputbuffer(70) –>sp_prepexec;1 thanks

---

Hi,
process id 57 is causing blocking, i suggest to read related topics in Forum,and articles
http://vyaskn.tripod.com/anti_blocking_strategies.htm http://www.sql-server-performance.com/blocking.asp http://www.sql-server-performance.com/reducing_locks.asp http://www.sql-server-performance.com/sf_block_prevention.asp http://www.sql-server-performance.com/q&a26.asp
Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami

---

Hi, why the lock is placed in the first place? why the other transactions are not executed.
In the previous reply process id 57 is blocking and executed query is
select property_value from application_property where system_code=’DEFCRTNAM’ and relation_key=21234 how the select statement performs blocking?

---

How many rows are in that table? Madhivanan Failing to plan is Planning to fail

---

Hi, In that blocking process executed query is
select property_value from application_property where system_code=’DEFCRTNAM’ and relation_key=21234 there are 1836 rows are available. is this because of any problem?

---

Hi,
read "eadlocks, overview" in BOL for more about DEADLOCK. Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami

---

]]>