Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Hardware
Message
From
02/07/2009 14:57:41
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Environment versions
SQL Server:
SQL Server 2008
Miscellaneous
Thread ID:
01409786
Message ID:
01409833
Views:
50
>I am looking at getting a new server to run SQL 2008 Standard. It will be running Windows Server 2008 standard also.
>
>Where should I invest to get the best performance for the cost?
>
>CPU(s) - Multiple core and/or Multiple socket?
>Memory - up to 32GB, is it worth it to go that high?
>drives - 7.2K v 15K, SATA v SCCI?
>Fancy Raid controllers/network cards or go with onboard?


We just did test back here to see where our app was hitting the hardest. The biggest increase for us was memory (we went to 12gig) and once that was increased the next thing was drives. Once those where increased the next bottle neck was processor but even with it hitting the limit on the processor the app was blazing fast so we never increased the processor. I agree with William go 64bit on the server. My opinion the intel onboard raid is usally good enough but the cards are better but if I'm cutting corners that's one of them.
Charles

"The code knows no master." - Chuck Mautz
"Everybody is ignorant, only on different subjects." - Will Rogers
Previous
Reply
Map
View

Click here to load this message in the networking platform