Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

  1. 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.
  2. If we do above, do we need to host its own db replicating with main db? If yes, how to do it?
  3. 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?

share|improve this question
    
what process is driving the cpu to 100%? –  tony roth Jun 20 '13 at 13:53
    
never mind reread your description. –  tony roth Jun 20 '13 at 14:05
    
The traditional answer would be to seperate the sql server, but if you have poor queries that might not solve anything. –  tony roth Jun 20 '13 at 14:09
    
@tonyroth thank you for your response. I agree with you, and also look into optimizing queries part. What do you suggest to host a complete admin panel on different server with its own sql db (which is a replication of live server db)? Is it going to work. I'm not sure how replication work.. can we have a replication like changes from both db are synchronized. For the db server connected to front-end only ordering and log tables are going to be accessed. While for admin site other tables will be accessed. What do you suggest. –  Krunal Jun 21 '13 at 6:32

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.