Real-World Database Layouts

Now that we’ve covered the fundamentals of databases, let’s pull all of the concepts together and apply them to define the structure of the databases for three applications—simple, moderately complex, and complex—given a fixed number of disk drives, a set of application characteristics, and a set of requirements.

Simple Application Workload

Scenario: In this scenario a user has a very simple application that utilizes a backend SQL Server 2005 database as a data repository for a small application. The maximum database size is estimated to be 8 GB with the data access somewhat evenly distributed across all the tables, with an average 95 percent read and 5 percent write data access ratio. The user would like to protect the ...

Get Microsoft® SQL Server™ 2005 Administrator's Companion now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.