Microsoft SQL Server 2012 Performance Tuning Cookbook

Chapter 14. Implementing Physical Database Structure

In this chapter we will cover:

• Configuring a data file and log file on multiple physical disks
• Using files and filegroups
• Moving an existing large table to a separate physical disk
• Moving non-clustered indexes to a separate physical disk
• Configuring the tempdb database on separate physical disk

Introduction

Your database performance heavily depends on how you have physically placed your database objects and how you have configured your disk subsystem. Designing the physical layout of your database correctly is the key factor to improve the performance of your database queries and thus the performance of your database. However, the correct decision on a physical design structure of the database depends ...