October 20, 2003 at 9:28 am
Hi,
We're seeing deadlocks caused by "lock resources", according to the error capture info. I would like more specific information re: lock resources. Does this mean I'm running out of available locks, like in the SQL 6.5 days, or is simply new SQL 2K vocabulary for describing a good ol' 2-users-want-each-other's-resources deadlock?
Thanks,
Paul
October 20, 2003 at 10:54 am
Interesting. Can you set an alert and capture sp_lock when the deadlock occurs. Might help with determining the answer.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
October 21, 2003 at 12:16 am
Are you using Temp Tables in your code ?
October 23, 2003 at 6:35 am
Thanks for the replies.
No, no temp tables used.
Steve, I will try to set the alert, however, these deadlocks only occur under very high load, which typically only happens once or twice a year for us, and that time has now passed.
P
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply