locked
SQL Server 2008 Replication and Windows Server 2008 RRS feed

  • Question

  •  

    Are there any sources of information available that can provide performance measures of SQL Server 2008 Replication running on Windows Server 2008 versus various other configurations?  My main interest lies in the performance gains under differnt topologies centered around transactional replication.  I recall there being something floating around about the performance gains combining SS2008 replication on top of WS2008 versus on top of WS2005, or prior versions of  SS replication.

    Friday, October 24, 2008 6:28 PM

Answers

  • There are improvements in snapshot delivery.

    http://blogs.msdn.com/buckwoody/archive/2008/05/05/windows-2008-and-replication.aspx
    Friday, October 24, 2008 7:00 PM
    Answerer

All replies

  • There are improvements in snapshot delivery.

    http://blogs.msdn.com/buckwoody/archive/2008/05/05/windows-2008-and-replication.aspx
    Friday, October 24, 2008 7:00 PM
    Answerer
  • We will be releasing a whitepaper in the next few weeks providing the details around the benefits and a case study. Essentially replication automatically gets the benefits from the new TCP\IP stack and the dynamic window sizing capability. Pull replication benefit more since we try to read as much data as possible over the wire than in the case of push subscription where we limit the amount of data send to 40K chunks.

     

     

     

    Wednesday, October 29, 2008 8:55 AM