Posted by Don Vaillancourt on 01/13/06 21:01

We have a problem with a table giving us deadlock issues and we can't
figure out why.

It's a table we write to fairly often perhaps 50 times a minute. And
also do a select of 200 rows at a time from 4 servers every 5 minutes or so.

We are only keeping 48 hours worth of rows in the table which averages
at 30000 a day on a busy day.

This table has 1 PK and 2 FKs plus one TEXT column which does not
participate in the WHERE clause.

We are using binded variables.

We have applied the latest patch to SQL2003 server running on
Windows2003. The patch is supposed to resolve deadlock issues.

Anyone have any advice on how to alleviate this problem.

Thanks

• Next in forum: Re: Baffled! Can't figure out how to do this query. Is it even possible?
• Prev in forum: Baffled! Can't figure out how to do this query. Is it even possible?
• Thread view: Deadlocks, why?

[Reply to this message]