DBInsight's Blog

Archive for Replication

Transactional Replication Performance and Virtual Log File Counts

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. Initially I thought that either the Log Reader or Distribution agent had a connectivity […]

Continue Reading →

Posted in: Performance, Replication

Leave a Comment (0) →

Transactional Replication Identity Column Hell

Recently I re-created 80+ Transactional Replication publications with Updateable Subscriptions as part of a data centre move. The data centre move process included a custom log shipping process to create and maintain the 80 “publication to be” databases in the new data centre server, at cut over the original SQL Server transactional replication to other […]

Continue Reading →

Posted in: Replication

Leave a Comment (0) →

Transactional Replication VS Availability Groups for Read Only Workloads

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 :- You don’t have to replicate everything when using TR, you can select tables, columns or even data subsets. You can also eliminate […]

Continue Reading →

Posted in: Replication

Leave a Comment (3) →