I picked up a new Dell R410 2.8 Ghz 12M cache 32 GB Ram RAID-1/RAID-1 for a good year-end deal. It was purchased mainly to replace my Dell PowerEdge 2850 which is my main WEB server. I run Windows Server 2008 R2 Standard across the board (several servers in my rack) and that's what I got with this new server. I'm happy with my R410 I got about two years ago, also 2.8 Ghz and 32 GB Ram which I use for SQL 2008 R2 Standard Edition tied to an iSCSI SAN (Dell MD3000i).
The new R410 is racked and I'm surprised to see it has 12 cores! Wow! Single proc, just like my other R410 due to the cost of per proc licensing of SQL. As I said I was going to use this server as my main web server which will have a lot of activity including WCF services for cloud functionality (data, sync, backups, etc.).
I'm always geared towards putting the best server as the SQL Server. I've been amazed at the speed of my R410 driving SQL but I'm wondering if SQL would better use the 12 cores as it only has 4, obviously an older proc from a year ago. Then again I'm thinking, if I have IIS working hard managing a lot of connections via web and WCF, would it better utitilize the 12 cores?
My web site does drive e-commerce but I'm a small biz. Should I put the new R410 as planned as the main WWW server or should I shuffle it around, make it the new SQL box and make the prior R410 that's a year old the new WWW box? Again, storage and disk I/O is via the iSCSI SAN for storage.
What would you do? Is it a clear decision or not? Part of me thinks just wait a year, get a new R410 in a year and make it the new SQL box as the business and services continue to grow. We have a major new product offering coming out this fall hence our build up. We have older 1750's, 1850's, and 2850's also in the rack for web load.
Thank you for your opinion as we're ready to put the new server to use early next week.