What kind of server architecture do I need for this kind of application to make it more reliable.
eCommerce application with abt 100,000 product with moderate to heavy traffic. The site performs very well if there is no admin usage. However with admin site being accessed by many people, we see a degrading performance.
With heavy admin activity we see CPU reaching to 100, including SQL taking most of it, and other is consumed by w3wp. I know I need to optimize SQL queries too. But we're under very pressure, and we can look at it after some time only.
Its be hosted on Win Server 2008 R2, IIS 7.5, ASP.net 4.5, MSSQL Server R2. Application is build on MVC4 and using Apache Solr 3.6.
The complete stack is on same system.. i.e. ISS, MSSQL and Apache Solr (hosted on Tomcat) are on same server.
Currently its hosted on one dedicated server. We plan to add another server, and need your help here.
- Do we need to host admin application on separate server? As with many admin using we start to see an issue. Otherwise site just performs fantastic.
- If we do above, do we need to host its own db replicating with main db? If yes, how to do it?
- Or do we need to host MSSQL on separate server? So we'll have SQL in one and Application on another server which will also host Solr. Note that all catalog pages are using Apache Solr's and not db. And may be host just admin application on local server only accessible from intranet.
Any help will be appreciated. What would you suggest?