Home > IT Blogs > SQL Server with Mr. Denny/

SQL Server with Mr. Denny:

Network Traffic

1
May 28, 2012  2:00 PM

Know your app when migrating your data



Posted by: Denny Cherry
Migration, Network Traffic, SQL Server

One of the projects that I'm working on at the moment is moving a data center from being hosted in Dallas Texas up to New Jersey so that it's closer to the companies corporate office in New York City.  As a part of this data center migration the Microsoft SQL Server databases must be moved to the...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

September 29, 2008  11:00 AM

Decreasing Network Traffic and Network Latency When Using Replication



Posted by: Denny Cherry
Network Latency, Network Traffic, Replication, SQL Server

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...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

1