Home > Uncategorized > SQL SERVER RAID consideration 2

SQL SERVER RAID consideration 2

RAID 0: Offer only disk striping and there is no redudancy. No redudancy – no fault tolerance, if disk fails all data is lost. RAID 0 is not recommended for storing SQL Server data files, log files or operating system files.

RAID 1: known as mirroring (duplicates your data disk). High level of fault tolerance. Raid1 is costly bacause you must double the number of disks. RAID 1 support split seeks, so both disk drives perform read operation. RAID 1 can support twice the number of random reads that a single disk can. Writing to RAID 1: write capacity of a single disk drive.

RAID 5: Good level of fault tolerance.It’s an economical, fault-tolerant choice. Fast with random reads, all disk drives can perform read operation. Slow with write operation, when data is written to RAID 5, disk stripe and the parity must be read, parity need to be calculated and then both stripes must be written.

RAID 10: Mirroring a disk stripe, each disk have a duplicate. High performance and high level of fault tolerance, but very expensive. Good random read performance, all disk drives can perform read operation. Write performance of RAID 10: same as with RAID 1.

1. Disk array configuration:

OS files and SQL binaries:RAID 1

Data files: if database is read only use RAID 5 (or >= 90% read and 10% write), for other databases use RAID 10 (better write performance).

Log files: dedicated RAID 10 (or RAID 1 ) for better write performance

Tempdb: Best to use RAID 10

Advertisements
Categories: Uncategorized
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: