March 31, 2009 at 1:35 pm
Hi all.
Been doing some research on the latest processor technologies, and requirements for running SQL Server. This looked like a great place to start with some questions I had.
I'm trying to put together a Min and Reccomended spec for a SQL Server (2005 or 2008 preferably running on Windows Server 2003 or 2008) that:
* Can handle 30k-50k transactions a day
* Data is basically graphical in nature, so large amounts of graphical data will be crunched and spit back through the SQL server
The key here is raw horsepower. The faster the better. Clustering shouldn't be an issue, so SQL Std and Win Srv Std should be fine here.
At a bare minimum I ascertained that I'd probably be looking at:
* Intel Core 2 Duo 2.6ghz
* 4GB RAM (DDR-2 8600)
* 500 GB of storage on a 7200rpm SATA (3.0gbs) and RAID 1 or 5 based setup
* Windows Server 2003 or 2008 Standard
* Dual 10/100 NICS, perhaps in a teamed mode
My recommended stats would be something along the lines of:
* Intel Xeon Quad Core, 3.0ghz
* 8GB RAM (either DDR-2 8600 or DDR-3 12800 )
* 1TB storage on a 10000rpm SATA (3.0gbs) and RAID 1 or 5 based setup
* Windows Server 2003 or 2008 Enterprise
* SQL Server Standard
* Dual gigabit NICs, perhaps in a teamed mode or even load balanacing with Win Enterprise
Thoughts?
I don't need to get into brand specifics, but recommended hardware (PERC controllers, etc) are greatly appreciated.
Thanks!
April 1, 2009 at 8:39 am
Anyone?
April 1, 2009 at 9:12 am
we're an HP shop here and the generation 6 servers just came out or are about to come out this week
HP Proliant DL 360 G6 ( up to 144GB of RAM on that baby)
comes with the new Nehalem CPU's and 6GB of RAM
P800 RAID controller
MSA 60 for the SATA drives and buy as much as you want (they also have a bundle where you buy it and 12TB worth of storage. we just paid $5500 for two of them)
the server starts at less than $2000, HD's are extra.
April 1, 2009 at 10:28 am
You don't want R5 if you have many writes. (http://www.baarf.com) Go with R1 or R10, be sure that you have separate arrays for data and backups.
Any of the major vendors have good Raid controllers. I'd go with the brand the server manufacturer uses. Less driver issues. You can put a DELL PERC in an IBM, but I wouldn't.
As far as sizing, you'd have to have tested some levels for your app. 30-50k transactions, are those reads, writes, combinations? What about peak/sec?
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply