Hello,
do you know defined performance differences between SQL 2000 and SQL
2005?
thanks in advance
I can't compare directly - there are loads of enhancements in the
architecture, some of which have no direct comparison eg a lot of what was
originally done in post snapshot scripts can now be done directly and merge
has unidirectional articles which aren't logged using triggers etc - also we
have different hardware between the installations.. For a quantitative
comparison where things are held constant as far as possible, have a look at
this article:
http://www.microsoft.com/technet/prodtechnol/sql/2005/mergrepl.mspx. If
applies to merge, but some of the snapshot details will equally apply to
transactional also.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
Showing posts with label sql2005thanks. Show all posts
Showing posts with label sql2005thanks. Show all posts
Thursday, March 22, 2012
Subscribe to:
Posts (Atom)