I have a social networking site with 100000 members and around 1000 concurrent users.
I am looking for architecture recomendations as my servers keep crashing.
The site is build in Coldfusion 7 and MS SQL (all sql is in stored procedures).
4 Windows 2003 servers.
One is for the db and has 2 procs with 4gigs ram.
Two web servers with 2 procs and 2 gigs ram
One server that stores and serves the members photos (this in particular gets really slow) Same specs as web servers.
Would this be an issue of IIS 6? Can it be the application pool? Web garden?
Please let me know what do you think is the proper architecture for this site. Keep in mind the traffic is increasing by 3-5% daily, so i need room for growth.