JeeKay (7/14/2008)
Hi,DO you have the different types of Isolation Levels in SQL 2 K like 2005 ? I was not aware. I will try to do some reading on that.
Sorry, it doesn't. I looked at the forum this was posted in and missed your version note. (btw, SQL 2000 posts should go into the SQL 2000 frums, for precisely that reason)
This is on SQL 2K and to make matters worse it has this crap design. Since the design change is not an option, I have been trying to think of various options like killing a blocking transaction if its blocking for more than a period of time, query governor limits etc.
Post your table design, indexes and some of the worst offending queries please. I like fixing deadlocks but is hard to offer solutions without seeing the details.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability