Optimizing the Database
The data tier is the part of a distributed application where information is centralized. That means it’s one of the most difficult parts of a distributed application to scale out because it maintains state. It’s worth squeezing out every extra ounce of performance you can.
Modern database products have come a long way. Microsoft architects confess that, only a few years ago, almost all the leading PC-based relational database management system (RDBMS) products had major limitations with reliability and data integrity. Today these problems have been fixed across the board, and all enterprise-level databases provide a sophisticated set of features for optimizing the speed that queries and updates execute.
Unfortunately, these ...