whorsfall
asked on
SQL 2012 Raid questions?
Hi,
I am looking to get some general guide on SQL 2012 in regards to disk IO on a Raid disk. (I will be
running this on Windows 2008 R2 x64).
So I have two questions in this area:
1. What is the best way to split the installation up. I think it is data on one drive, logs on another
etc?
2. Ok in regards to the drive splitting does it make a difference if the different logical drives
are on the same physical disk.
i.e. D: E: and F: <--- are all on a logical disk that sits on one physical disk that is mirrored with
another.
as opposed to.
D: E: and F: being seperate physical disks that are mirrored?
Thanks,
Ward
I am looking to get some general guide on SQL 2012 in regards to disk IO on a Raid disk. (I will be
running this on Windows 2008 R2 x64).
So I have two questions in this area:
1. What is the best way to split the installation up. I think it is data on one drive, logs on another
etc?
2. Ok in regards to the drive splitting does it make a difference if the different logical drives
are on the same physical disk.
i.e. D: E: and F: <--- are all on a logical disk that sits on one physical disk that is mirrored with
another.
as opposed to.
D: E: and F: being seperate physical disks that are mirrored?
Thanks,
Ward
This is how RAID should be used with database files.
RAID Type of Raid Gen.File Database File Redo Log File Archive Log File
0 Striping Avoid OK Avoid Avoid
1 Shadowing Best OK Best Best
1+0 Striping and Shadowing OK Best Avoid Avoid
3 Striping with static parity OK OK Avoid Avoid
5 Striping with rotating parity OK Best if RAID0-1 not available Avoid Avoid
ASKER
Hi,
Thanks for that. What does "Gen.File" mean.
Also does it make any difference raiding the share feature (SQL binaries)?
Thanks,
Ward
Thanks for that. What does "Gen.File" mean.
Also does it make any difference raiding the share feature (SQL binaries)?
Thanks,
Ward
"What does "Gen.File" mean."
General file serving?
"Also does it make any difference raiding the share feature (SQL binaries)?"
You can end up with some fault tolerance. In some cases you can improve performance too.
General file serving?
"Also does it make any difference raiding the share feature (SQL binaries)?"
You can end up with some fault tolerance. In some cases you can improve performance too.
Word of advice... Looks like your question did get answered though point I want to make is with regard to wether you need to worry about the disk I/o optimization.
Unless you are experiencing latency problems now, simple disk mirroring compared with any of the above will perform equally for small installations. The criteria for determining optimal configuration for SQL should be knowing what your workload is ie. number of transactions and so on....
Unless you are experiencing latency problems now, simple disk mirroring compared with any of the above will perform equally for small installations. The criteria for determining optimal configuration for SQL should be knowing what your workload is ie. number of transactions and so on....
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
2) Yes. Ideally the separate drives would be accessed via separate controllers. If the logical drives are on the same physical disk, you lose some benefits of the separation. That said, with a properly configured RAID, it may not make much difference.