Mejoras en Replicación en SQL Server 2008 con Windows Server 2008
Parece que los equipos de Windows y SQL han trabajado juntos para mejorar el rendimiento de las réplicas en SQL Server 2008; las diferencias de tiempos son notables :)
Texto extraido del siguiente post:
http://blogs.msdn.com/buckwoody/archive/2008/05/05/windows-2008-and-replication.aspx
"Windows Server 2008 includes a new networking stack, redesigned and rewritten from the ground up, with modern protocol implementations. Besides making IPv6 a full-fledged peer of IPv4, it supports better perf over high-latency, high-loss nets.
In [SQL Server 2008] Katmai, the DP & perf teams collaborated with Windows core networking, so SQL networking could take better advantage of the new stack. The impact of this work can be seen in just-completed replication testing, between two sites separated by over 2,000 miles.
The results are nothing short of eye-popping. A pull replication scenario, which used to run in 223 minutes using [SQL Server 2005] Yukon on Win2K3, takes just under 2 minutes on [Windows 2008 Server] Longhorn server with Katmai. And an 11.3GB snapshot was sent >2K miles in ~23 minutes, a rate of almost 500 MB/minute. That’s BYTES, not bits. Talk about “better together”!"