jefydominic (4/25/2011)
Hi All,We are planning to setup a new SQL server 2008 (enterprise edition).
Average data size is 100GB. Every weekend we will delete some data and add some new data to this database, around 10Gb data we will update in every week. Other 5 days in every week we just read and show these data in our application, So our main concern is data read should be more efficient, we are more looks on performance of data Read operation.
Our suggested hardware configuration is given below.
CPU :- 2 Intel 64 bit processor speed 3GHz or more
Hard Disk :- 2 RAID drives (SCSI fiber channel)
1. RAID 1 - for data storage
2. RAID 1 - For OS and SQL server applications
OS :- Windows 2008 64bit
RAM:- 4GB per processor, total 8GB
Please review this hardware configuration and advice me, is this good? what is your suggestions?
Thank you
Jefy
So you want to quickly serve up 100GB of data on a server with just 8GB of RAM and only TWO rotating hard disks??? Um, good luck with that?? My LAPTOP has 2 hard drives! If you had 32 or better yet 64GB of RAM you might get away with that, but if you have either large reports that need to read lots of data or random IO requests spread throughout the 100GB of data you are in DEEP trouble with that poor IO subsystem.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service