Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chewie
Starting Member
4 Posts |
 Posted - 2009-03-31 : 15:32:50
|
| 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 serverThe 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 modeMy 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 EnterpriseThoughts?I don't need to get into brand specifics, but recommended hardware (PERC controllers, etc) are greatly appreciated. Thanks! |
|
|
chewie
Starting Member
4 Posts |
Posted - 2009-04-01 : 10:35:43
|
| Anyone? |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-04-01 : 10:37:23
|
| I would suggest to get more RAM and 64-bit (if possible)? Also get RAID 10 drive for TempDB and log files. |
|
|
|
chewie
Starting Member
4 Posts |
Posted - 2009-04-01 : 10:41:18
|
| Thanks but, what about the hardware setup?Thoughts on that?How much more is 'more ram'?I should note that 64bit is not an option due to some software restraints. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-04-01 : 10:45:37
|
| 'More ram' depends on how high your transactional system? |
|
|
|
chewie
Starting Member
4 Posts |
Posted - 2009-04-01 : 10:59:50
|
| 30k-50k transactions a day |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-04-01 : 11:16:11
|
| More RAM = as much as the box can handle, or, however much you can affordSeriously, the more the better. It's probably the single most cost-effective improvement you can make. If you're using 64 bit then 8 GB should be the absolute minimum. Talk to the vendor, you may get a good deal for extra RAM. (We got 32 GB for the price of 16 on one of our boxes, and we had an option to get ANOTHER 32 GB for $700 more, which unfortunately we didn't order) |
|
|
|
|
|
|
|
|
Need advice on hardware setup