Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tristans
Starting Member
2 Posts |
 Posted - 2008-09-09 : 13:37:03
|
I am ordering a new SQL server to try to "speed up" our current database.The current system has a RAID 5 array consisting of 3 physical disks which have been cut into two partitions - C: and D: respectively. The system is running on SQL 2005 WorkGroup edition with 4 GB of system RAM. All files (OS, User DB's, System DB's, Log Files, etc.) are on these drives. The main user DB's are "Pharmacy", "Limited", and "FDB". See file sizes below: We had a SQL consultant come in to have a look at how we can increase performance of the DB and one of his suggestions was moving the file elements (Log Files, DB's, OS, etc.) to separate dedicated drives\array's. We decided to to just get a new server and not mess with reconfiguring the old one.I am getting a Dell PowerEdge 2900 with a 2.66 GHz Quad Core processor (can add 2nd processor later) and 16GB of memory running on Windows Server 2003 x64. Also going to run SQL Standard 64-Bit. The server comes with an 8-port embedded SAS RAID and 2 onboard SATA connectors (non-raid). I was going to order 9 x 73GB 15,000 RPM SAS hard drives and configure them as follows:-RAID 0 (2 drives) = TempDB1, TempDB2, TempDB3, TempDB4-No RAID (1 drive) = OS,SQL install,System DB's-RAID 3 (3 drives) = Pharmacy.mdf, Limited.mdf, FDB.mdf-RAID 0 (2 drives) = SQL Log FilesPlease let me know if this is an ideal configuration for IO performance and keep in mind that the RAID cannot exceed 8 drives and the system can only hold 10 drives. Thanks for your input.PS: I am also aware than any drive failing in a RAID 0 config or no RAID config will bring down the data on that drive\array. We can afford some downtime (a 2-3 hour downtime to restore the OS for example would be acceptable).Tristan Smit |
|
|
tristans
Starting Member
2 Posts |
Posted - 2008-09-10 : 14:41:38
|
| Another question... What about SSD drives? Would a single MTron SSD outperform two 15K RPM drives in RAID 0? If so I'd consider using SSD drives as the 16 and 32 GB models would fit the bill for my database and log sizes.Any input\recommendations would be greatly appreciated. |
 |
|
|
|
|
|
|
|
Configuration of Hard Drives on new server