Does the database compatibility level setting affect merge replication
performance on 2005?
Thanks.
Yes, but how much is depends on the switches you use. Have a look at this
white paper to see what the improvements could be.
http://www.microsoft.com/technet/pro.../mergrepl.mspx
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Brett" <johbrett@.gmail.com> wrote in message
news:eT0uaMHSGHA.3192@.TK2MSFTNGP09.phx.gbl...
> Does the database compatibility level setting affect merge replication
> performance on 2005?
>
> Thanks.
>
|||Thanks for the reference.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:uFCQOIPSGHA.4384@.tk2msftngp13.phx.gbl...
> Yes, but how much is depends on the switches you use. Have a look at this
> white paper to see what the improvements could be.
> http://www.microsoft.com/technet/pro.../mergrepl.mspx
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Brett" <johbrett@.gmail.com> wrote in message
> news:eT0uaMHSGHA.3192@.TK2MSFTNGP09.phx.gbl...
>
Sunday, February 19, 2012
2005 merge replication and database compatibility level setting
Labels:
affect,
compatibility,
database,
level,
merge,
microsoft,
mysql,
oracle,
replication,
replicationperformance,
server,
setting,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment