olisemalis
MIS
Hello all,
I´m using asp.net 2.0 with defaults (pooling and timeout).
Sudently I starting getting locks/deadlocks in my database.
For each locking I run dbcc inputbuffer (spid). I hope this command will return the last sql statment each spid is trying to execute. I get something like this:
135 (blocked by 243)
SELECT field1, filed2, fieldn FROM TableA WHERE field = 1 AND otherfield =31
243 (blocked by 449)
SELECT Field1 FROM TableB WHERE field = 225
449 (blocked by 135)
INSERT INTO TableC(Tipo, GUID) VALUES (1854,'11/13/2007 10:08:35 AM0.533424')
269 (blocked by 243)
exec MySP '(10,101,2129,2131,2134)
If dbcc inputbuffer is right, I dont understand how the first 3 are blocking itself if the database of the running sql statement is different!
Any ideas?
Thank you
I´m using asp.net 2.0 with defaults (pooling and timeout).
Sudently I starting getting locks/deadlocks in my database.
For each locking I run dbcc inputbuffer (spid). I hope this command will return the last sql statment each spid is trying to execute. I get something like this:
135 (blocked by 243)
SELECT field1, filed2, fieldn FROM TableA WHERE field = 1 AND otherfield =31
243 (blocked by 449)
SELECT Field1 FROM TableB WHERE field = 225
449 (blocked by 135)
INSERT INTO TableC(Tipo, GUID) VALUES (1854,'11/13/2007 10:08:35 AM0.533424')
269 (blocked by 243)
exec MySP '(10,101,2129,2131,2134)
If dbcc inputbuffer is right, I dont understand how the first 3 are blocking itself if the database of the running sql statement is different!
Any ideas?
Thank you