Post reply

simple question

  • January 23, 2006 at 9:54 am

    #364773

    We are thinking about separate Sqlserver from webserver into two different servers, but don't know the performance will be affected or not. If do, how much? Like the data access time.

    Thanks

  • January 23, 2006 at 9:59 am

    #616484

    Simple question, but not a simple answer !!

  • January 23, 2006 at 10:16 am

    #616489

    Sorry, for the limited information.

    We are running a e-commerce website, the website, warehouse management software all need to access database frequently, and average transaction is about 25000 to 30000 a day. So need some advices for this.

    Thanks

  • January 24, 2006 at 9:21 am

    #616707

    You should put SQL Server on its own server and then create a backplane between SQL Server and your webserver, so that only internal traffic follows between the SQL Server and your webserver.  You could even set it up on a GIG backplane. 

    25,000-30,000 trans a day should be a fine over a network. 

  • January 24, 2006 at 10:25 am

    #616723

    I will add on that we have multiple web servers that back each other up and the talk to a clustered pair of SQL Servers.  So yes seperate them, it will let you achieve better fault tolerance.  Do put a fast network communications between them however.

     

    Good luck.

  • January 24, 2006 at 12:26 pm

    #616748

    Thanks a lot. Will try it.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply