I want to install SQL server 2008 R2 and IIS on same server with a mirroring configuration with principal/mirror/witness setup. Both principal and mirror servers will have IIS and SQL server. My question is twofold:
1) Will additional ram to the principal server be enough for smooth operation? Here we can assume a payload of about 50-100 http requests per second and flat database structure. Storage is RAID 5 or 10. Will it be better to have more than one CPU, is one multi-core CPU good enough?
2) Will automatic fail-over work for IIS as well as SQL server? for example if IIS crashes (or something else in the OS besides SQL server (some service, power supply, etc..., but no hard-disk failure)).
Thanks in advance.