Page 1 of 1

One DB multiple IIS servers

Posted: Jul 18, 2008 5:59 am
by dyawlak
Is it feasible to host a single instance of the database in one location and host multiple instances of IIS across different regions. We have a latency issue with some places, and as part of our investigative approach into finding a workable solution, we were going to setup up regional IIS boxes pointing back to one MSSQL server.

Thanks

Re: One DB multiple IIS servers

Posted: Aug 13, 2008 7:07 pm
by vboctor
I would expect the proposed setup to be slower. Since the client does 1 request from the remote IIS server in the current setup, but with your proposed setup, the IIS will do multiple requests from the DB over the slow connection. Hence, I don't think it will work for you. I would locate the server (IIS+DB) in the location with least latency to all other branches.