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 |
|
Nostradamus
Starting Member
1 Post |
 Posted - 2009-03-18 : 16:19:18
|
| Hi there,I have an office in the UK and an office in Florida, USA. As part of a financial trading package there is a fairly straightforward Write to the DB every hour or so. It only amounts to 15 rows of data on one of the tables. However financial buy/sell orders are dependent on the data being bang up to date. So my question is can WCS on Windows 2008 Enterprise in conjunction with SQL Server 2008 Enterprise work in a timely fashion across the Atlantic. The ping times between the servers are just short of 90 ms. The US site uses a dedicated T1 line and the UK site an uncontended 2 MEG SDSL connection.Any opinions / suggestions would be greatly appreciated.CheersStephen |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2009-03-18 : 16:39:33
|
| The two options with the smallest foot print are having your primary server in the UK and your mirror in the US with a snapshot off the mirror( assuming you only need read only in the US). High performance(asynchronous) or high safety(synchronous) mirroring would probably be sufficient and then rebuild the snapshot hourly. Option 2 would be transactional replication which would send the smallest amount of data to the US server. If you need to update just the one table I'd go with the transactional replication. If the whole database needs to be in synch then high performance mode mirroring might be better. Maybe log shipping would work but I'm less confident there.Mike"oh, that monkey is going to pay" |
 |
|
|
|
|
|
Trans-atlantic clustering