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 .
Thursday, March 22, 2012
Difference between 2000 and 2005
Labels:
database,
defined,
differences,
microsoft,
mysql,
oracle,
performance,
server,
sql,
sql2005thanks
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment