I'm testing a very simple web application that basically reads and updates to two or three tables. Due to this there is a locking problem when you put high load on it, there will be an extreme high number of updates, inserts and selects to the same tables.
The reads needs to have clean data so you can't use NOLOCK hints. Any suggestions on how to minimize this problem?
View Complete Post