I am looking for the best approach to configuring a new Server install with SQL 2012
We have a Proliant DL380p Gen8 server 2 CPU, 4 cores (so 8 cores total) Win2K8 Enterprise 8GB Memory
2 Smart Array 420 controllers 10 Disks.
My thinking was to do the following: 2 Drives mirrored for OS 4 Drives RAID 5 on same controller as OS to hold MDF files
On the other controller 4 Drives RAID 5 to hold LDF files.
We currently have Windows 2K3 with SQL 2000 in place on DL360 G5's and it looks like the Disk I/O is the bottleneck when large queries are done.
So will the above disk splits work or should I just take and do 2 drive mirrors on all disks and then have 5 different logical drives vs. 3 logical drives using RAID 1 and RAID 5?Thanks for any help, Seth
asked Sep 28, 2012 at 07:30 PM in Default
First of all, if you can, go with Windows 2008 R2.
As regards storage, it really comes down to the kind of capacity requirements you have. If you have enough storage capacity to do RAID10 for your data and logs then I would highly recommend doing so (different RAID10 volumes for the data and logs just to be clear).
If that's not an option then RAID5 for the data and RAID10 for the logs.
If your transaction logs don't get that large you might consider a RAID1 for the logs with 2 drives and give the other 2 to the data files, remember the more spindles you can get to spread your data out the better off you will be.Out of interest, you don't mention backups here. Are you backing up your databases directly to a network location?
answered Sep 28, 2012 at 07:50 PM
More stress testing tools to be found here: http://sqlserverio.com/2012/08/16/free-tools-for-testing-sql-sever/#comment-873
answered Oct 01, 2012 at 01:12 PM
Check your current disk and Tlog utilization. You need to know in advanced if you have OLTP databases or long time running queries that read and barely do updates or inserts.
If you have long time running queries, like to generate reports. don't put mdf on RAID5, use RAID10. RAID5 won't give you the speed you need and if one disk goes down, it will be horrible slow, until you replace the disk.For the Tlog, RAID1 should be enough. Tlog read sequential so if you put ldf on RAID5 you are forcing the heads to write more than required , making the server slow as well.
answered Sep 29, 2012 at 01:57 PM