question

Junior_DBA_Bayou avatar image
Junior_DBA_Bayou asked

RAID vs. Physical drives set up

Junior DBA here and looking for suggestions on install with the following set up. I will have RAID 10, but partitioned drives. ( IT administrator ) holds key to server and demands this set up. I was going to split up like this: C:\ OS/Binaries D:\ Log files E:\ Temp DB G:\ Backups R:\ Data S:\ Data T:\ Data Because partitioned drives does splitting up data on three drives make any difference with performance? Any suggestions would be greatly appreciated considering circumstances! Thanks.
partitioningraid
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Junior_DBA_Bayou avatar image Junior_DBA_Bayou commented ·
Just to clarify: SQL SERVER 2014 BI Edition w/ 64GB RAM for 80% Reads
0 Likes 0 ·
Junior_DBA_Bayou avatar image Junior_DBA_Bayou commented ·
Thank you for clarification DenisT! That is what I was afraid the answer would be.
0 Likes 0 ·

1 Answer

·
DenisT avatar image
DenisT answered
There is no difference in performance by splitting 1x RAID-10 into multiple partitions.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.