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
I don't need to get into brand specifics, but recommended hardware (PERC controllers, etc) are greatly appreciated.