Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ourspt
Starting Member
33 Posts |
 Posted - 2006-11-14 : 03:01:49
|
| Hi,Our client is located in Europe region. Our application was a web based application using SQL Server 2000 database as the back-end, where this server was located in Europe region. All the users will visit this site through out the world. Now the client was observing some performance problems in their offices in Asia region. The reason seems to be a relatively bad connection between Europe and Asia. The available bandwidth should be by far sufficient (10 Mbit/s), but the latency seems to be too slow (approx. 350 ms). Our Client is checking with other providers, but they may have similar problems. The effect is that the measured response times in their Asian office are too long (typically 3 – 5 seconds). Their target is to get response times below 2 seconds to make sure that the users can work efficiently.One possible solution which has been suggested to us was that to install the web based application also on a server in the Asian office. There would be 2 mirrored databases with the same data. The users in Asia would access this server, whereas the users in Europe and America would access the server in Europe. Probably it would be sufficient to update the data once a day or even less frequently. Does SQL Server 2000 support such a solution? Do you think this would be a feasible solution? If this solution should be implemented, how should we proceed?Or else Can you suggest any other solution?Thanks and Regardsourspt |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-11-14 : 15:47:55
|
| You need to look at replication, which should be able to handle that very nicely. Probably for your scenario you'll use transactional replication with a central publisher topology but you can figure all that out from Books Online. |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2006-11-14 : 15:59:23
|
| I agree. I'd look into Replication or Log Shipping. Michael<Yoda>Use the Search page you must. Find the answer you will. Cursors, path to the Dark Side they are. Avoid them, you must. Use Order By NewID() to get a random record you will.</Yoda>Opinions expressed in this post are not necessarily those of TeleVox Software, inc. All information is provided "AS IS" with no warranties and confers no rights. |
|
|
|
|
|
|
How to implement Database Mirroring with SQL2000