Other Performance Considerations
In this section, I’ll provide a brief background about designing and architecting write-intensive systems. I thought that such background might be interesting for programmers, particularly in terms of realizing that there’s a lot involved in designing systems when aiming for good modification performance. If you’re not familiar with the terms described in this section, feel free to skip it.
You can find more thorough coverage of the subject and more detailed explanations about the terms discussed here in Inside Microsoft SQL Server 2005: The Storage Engine (Microsoft Press, 2006) by Kalen Delaney.
You need ...