Tuning the Database Layout
In Chapter 10, we examined creating databases in detail. We also also looked at disk I/O subsystems and the various levels of RAID in Chapter 4 and Chapter 7. There are a number of techniques that you can use to optimize performance at the database level.
Database Layout
Perhaps one of the easiest techniques that a DBA can employ to tune his or her databases is to take advantage of the file and filegroup architecture supported by SQL Server databases. Don’t forget that you can change your file and filegroup strategies once a database has been created.
Note
Don’t forget to put your transaction log onto a separate spindle for your OLTP databases to separate your sequential transaction log I/O from your random database I/O. ...
Get Microsoft® SQL Server™ 2005 Administrator's Companion now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.