Unsolved
This post is more than 5 years old
2 Posts
0
554
April 1st, 2009 10:00
SQL Server Hardware Considerations - need advice
| 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 branding specifics, but recommended hardware (PERC controllers, etc) are greatly appreciated. |
Also, this will be strictly 32bit for the time being.
Also:
* Will be up 24-7
* Growth of 20-30% expected between 3-5 years.
* OLTP based client/transactions
No Events found!