I have a couple tables and application service that intensively inserts, updates its. From the other hand some client application have to read data using those tables. Sometimes client application gets timeout exceptions because of locks this shared data. What the common or maybe non-ordinal solution to separate intensively modified data and fast reading the same one. By the way, data can be consistent but can be delayed in time for 10-20 seconds (for example). OLAP cannot be used.
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
Use Snapshot or Read Committed Snapshot isolation for your reads.