Sunday, February 19, 2012

2005 merge replication and database compatibility level setting

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...
>

No comments:

Post a Comment