|
Subject:
|
1 Server in Central location / 1 server each
|
|
Posted By:
|
Scripts82
|
Post Date:
|
2/28/2006 3:10:45 AM
|
Hi guys!
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
Scripts82
|
|
Reply By:
|
SQLScott
|
Reply Date:
|
2/28/2006 8:59:30 AM
|
What is your database now if you are not using SQL Server? You will definately get a boost in performance by migrating to SQL Server, and I would put it in 1 centralized location based on the information above.
Do the databases contain the exact same information? If so, you have syncing issues to deal with if you put 1 in each location.
I would start by putting 1 in a central location and then monitor the speed. Adjustments can be made from there.
Scott
|
|
Reply By:
|
Scripts82
|
Reply Date:
|
2/28/2006 10:39:42 PM
|
Hi SQL Scott!
Currently on each site, there is one MS Access MDB File acting as the file server. The users access this MDB via a MS Access MDE file that contains all the forms, queries, reports and etc.
The 2 database contains different set of data. However, I will need to process both data sets for analysis purpose.
Thanks.
Scripts82
|
