Category: Replication

Transactional Replication Performance and Virtual Log File Counts
Posted by Rob Risetto on April 19, 2016

Recently I came across a client that could not get their Transactional Replication data transfer to complete within a reasonable timeframe. Replication initialisation would work ok but from then on no data changes would make it through to the subscriber database.

Continue Reading

Transactional Replication Identity Column Hell
Posted by Rob Risetto on March 16, 2016

Recently I re-created 80+ Transactional Replication publications with Updateable Subscriptions as part of a data centre move.

Continue Reading

Transactional Replication VS Availability Groups for Read Only Workloads
Posted by Rob Risetto on March 10, 2016

The Transactional Replication (TR) is still one of my favourite parts of SQL Server, and provides some distinctive advantages over Always On Availability Group (AG) Read Only secondaries. The TR advantages include :

Continue Reading