Best hard drive configuration for SQL Server
Posted on 2004-03-30
This question may be more a hardware question than SQL Server but I thought I would post it here first. I am about to order a new server from Dell that I will use only for SQL Server 2000 ( and SQL Server 2003 in the near future). Bare with me, I am not up to date on hardware but I wanted to know what the best hard drive configuration would be for use with SQL Server. The specs on the new server now contain 5 hard drives on a raid 5 array. The first two drives are 36 gigs each and will hold the OS (Windows 2003 Server) and the other three are 146 gigs each that will be stripped and contain the database. Regarding performance, is stripped the best option to use?
The database us used for a web based application written in ASP and ASP.Net that allows students to take tests online. The test questions, answers, statistics for each kid are stored in the DB. Also, the DB contains all enrollment information for each kid at participating schools. The current size of the DB is 5 gigs. At one time there may be from 50 to 100 users accessing this DB retrieving data for reports, retreiving data for tests or inserting new test information (test keys, student responses. etc) or class scheduling information. I also use DTS to import large amounts of data into the DB from text files (30,000 to 60,000 records).
Aside from disk configuration are there any other areas dealing with hardware that I need to pay special attention to with reards to DB performance?
This server will also have dual processors at 3.2GHz with 1MB cache and 4gigs of DDR SDRAM.