Decreasing Network Traffic and Network Latency When Using Replication
When dealing with a high load replication environment network latency and network traffic can become as issue. There are a few settings you can play with, within the subscription agents themselves such as the –PacketSize, -UseInprocLoader, and –SubscriptionStreams. While working with these settings may or may not help (personally I’ve had very limited success getting […]
A Load Balanced Federated Database Solution
If you have a very high load on your database, but no specifically massive tables you may want to look into a fully load balanced solution for your database. This solution falls somewhere between your normal replication solution, and a federation solution. It’s not truly a federation as no one table is spread across several […]
The full replication federation
Another type of database federation is what I call the full replication federation. This is where you place all the dimension tables (sticking with our data warehouse example from last time) on all servers of the federation. In addition to having the dimension tables on all the servers in the federation, we also allow all […]
Great Turnout At the San Diego SQL Server Users Group Last Night
I’d like to say thanks to the San Diego SQL Server Users Group for inviting me to speak last night. I had a great time speaking to the group, and just like last time the questions were all excellent. The slide deck for last night session on Federated Databases is now available. I believe that […]