THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Performance » Replication   (RSS)
  • Transactional replication and massive data updates

    SQL Server transactional replication has been a rather solid feature and works well for delivering data to reporting servers (among other things) in near real time. That said, it may not work too well when you need to perform massive updates on a published table, for instance, when you need to archive a large amount of data. It can take a long ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on October 6, 2011
  • Performance impact: implicit type conversions

    Often you see an implicit type conversion or a type mismatch causing a performance issue when it trips up the SQL Server query optimizer. A while back though, I ran into a case where a harmless looking type mismatch caused significant performance degradation when there was no bad plan involved.   So we had a rather straightforward ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on July 20, 2011
  • Distribution latency in transactional replication: Is a volume surge the culprit?

    If you use transactional replication, I have no doubt that from time to time you are asked to explain why there is an increased latency between the publisher and the subscriber. More often than not, this end-to-end latency is caused by latency in distributing the commands from the distribution database to the subscriber. So I’ll focus on ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on June 5, 2009
Privacy Statement