Physical Database Design for Performance

I found 3 techniques to boost SQL Server perfomance which are RAID, Partitioning and Filegroup.

RAID can be implement just by buying new hardware but it is costly. Though, it can be implemented by software. We need Windows NT or Windows 2000 to do that. Following is 3 techniques of RAID implementation

1. Disk Striping: Store same data to different physical disk.
2. Disk Mirroing: Redundant copy of data into another physical disk.
3. Disk Duplexing: Further protection against controller failure of mirroring.

All RAID implementation require additional hardware.

Partitioning can be hardware partitioning, horizontal and vertical partitioning. Hardware partitioning distribute query process into multiple hardware sucj as multiprocessor or RAID. Horizontal partitioning partition a singel table based on row. So do vertical partitioning.

Data placement into filegroup then can be implemented by placing table and index into filegroup on different physical disk.

All of the technique improve performance and reliability.