February 12, 2013 at 3:35 pm
OS: Windows Server 2008 R2
SQL Server: SQL Server 2008 R2 Std.
I recently upgraded one of our servers to become a new SQL-server, with a quadcore 3.16GHz CPU,16 GB DDR2-RAM and 2x72GB (RAID1) SAS-disks for C:\ and 6x146GB (RAID1+0) SAS-disks for database/log storage on D:\. The old one (current one) is a dualcore 1.86GHz CPU, 3 GB DDR2-RAM and 4x72GB in RAID5 - so for my company this should be a decent upgrade.
First of all; is this a bad setup? Should database/logfiles be placed on different drives? Should I change the disk setup?
Second of all; if this planning is OKAY, should I install the SQL-software to C- or D-drive?
Other input is welcomed as well!
February 13, 2013 at 1:46 am
Yes, your data files and log files, should be on completely different storage environments. So partitioning the D drive into D and E, but still using the same 2 disks isn't going to be better than just sticking them together on the D drive currently. They need their own seperate physical disks.
Also I would put an additional set of disks in for backups, so you data, logs and backups are on completly seperate independent storage.
You can install SQL to the C drive or D drive, it is entirly your preference, there isn;t much performance gain installing it on a drive thats not C.
Also remember to set your SQL Server's max memory, something around the 12-14GB mark if you have 16GB of RAM in the server.
February 13, 2013 at 2:20 am
I just checked our current SQL-server and it seems our total database-size is approx. 10 GB + logs + backups.
Considering I have 2x72 GB and 6x146 GB at my disposal, would it be better to set up the server like this:
2x72 RAID 1 = OS & SQL Software
2x146 RAID 1 = SQL DATA
2x146 RAID 1 = SQL LOGS
2x146 RAID 1 = SQL BACKUP
How would 3xRAID1 impact performance against 1xRAID1+0 w/6 disks?
February 13, 2013 at 2:40 am
Well you will have a smaller amount of IOPS available per RAID array, so you cant do as many read write operations a second as you could with 6 disks.
But with a DB that small I doubt you have the IOPS anyway to justify a RAID10 6 disk array.
But yes, I would setup the server with that configuration personally.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply