> I am looking for design ideas to minimize contention at the db level and eliminate the deadlocks and something that will scale well with more users.
Post the deadlock XML and queries involved, and the table and index DDL of the tables. It's usually just a matter of controlling locking behavior to force clients use a more restrictive lock earlier to avoid deadlocking.
Also describe the transactional behavior you need for the background tasks table.
David
David http://ift.tt/1c5QNcs
No comments:
Post a Comment