I have a web application that uses a single IIS web site. I want to provide an environment that will allow for growth yet not be overkill. What I want to do/host in my web app and my basic specs, are as follows:
IIS web application deployed in a web farm
SQL 2K5 server deployed in some sort of clustered or fail over environment
The database server will hold up to 500 database that are likely not to exceed 100MG in size
Basically, I'm confused on the wide variety of processors I can get in a dedicated server and the wide range of cost. Singles, duals, single/multicore, dual multicore, etc. I want my application to be very responsive, but at max there are likely never going to be more than 2000 individual users and not all using it at the same time.
Do I need load balancing?
software firewall or go to the extra cost for hardware?
How much RAM? I currently have all the application on a single dual xeon box with 4GB of ram and it works quite well. Do I get lower RAM or CPU on the web server and higher on the SQL box?
Anyway, those are my general questions on the subject.