I have an ASP.NET 4.5 web app running in IIS 7 and connecting to SQL Server 2008 R2 on the same machine. The database is very read intensive with the occasional heavy write burst. Currently we have a single CPU server but are planning to get a R720 Hex Core machine which has two sockets. Is there any benefit to getting a second CPU for the server and having IIS and SQL Server running on separate CPUs? How would you set this up to maximise usage of the hardware?
To any the question:
Any benefits: Yes.
If you pin the two processes to two different CPU's then both can make full use of the (2nd/3rd lvl) cache. That might be a bit faster. Two populated CPU sockets also yield more memory bandwidth.
Those are the advantages. However:
All of this is a very long winded way of saying maybe, it depends.
The only way to actually determine this is to measure your current bottlenecks.