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 |
|
Lumbago
Norsk Yak Master
3271 Posts |
 Posted - 2008-09-22 : 11:00:29
|
| Hi all,we're currently splitting up our production environment in two, having one part of the system in one country and the other part in another. There will not be very much data passing between these environments but it has to happen on a per-transaction level on a scale of 1-500 transactions per day. The environments consists of one clustered SQL2005 instance in one country and one standard SQL2005 instance in the other, accessible to eachother by VPN. I'm thinking about adding these as linked servers to eachother, but I've never really worked much with DTC or linked servers before...what do I need to think about when setting this up?- Lumbago |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-22 : 13:44:33
|
| It all depends on Network Bandwidth . |
 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2008-09-23 : 03:40:40
|
| Umh...ok? The actual data that's going across the network is probably less than 1k for each transaction. I was thinking more in terms of any special configurations in the DTC, security, reliability and such. Or is it just to plug and play?- Lumbago |
|
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2008-09-23 : 11:30:13
|
| If you create a vpn between the two servers, they will not know they are in different buildings. There is the possibilty of the latency of 100-200ms causing issues, but your server would just see that as a slow response in general. |
|
|
|
|
|
|
Linked server recomendations