O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required