1 Server in Central location / 1 server each
I have some decision to make regarding whether to deploy the database on 2 seperate servers or just 1 server. Hence hope that you guys can provide me with some information to help me in making this decision.
Below is the current situation.
Currently, I am maintaining 2 database used by 2 seperate groups of users. These 2 groups of users are based in 2 different sites, sites A and sites B.
In the past, the 2 databases are maintaind on a shared drive in sites A. However, unbearable data access speed by users in sites B prompted me to split the database into 2 -> 1 in country A and 1 in sites B.
With this backgroud, my questions are as follows....
If I migrate to the SQL Server, where should I deploy it? In 2 seperate locations or in 1 centralised location? Will I be expecting great increase in speed?
To give a rough idea of the current network condition that I am facing...
From sites A, to access a table in sites B will take 9 secs.
From sites B, to access the same table in sites B will take at most 3 sec