Andy Warren

Non-Continous Replicaton and The LogReader

Last year Andy wrote about turning off the log reader as a way to reduce the overhead on a server, primarily when you have many logreaders running. In this follow up article he talks about the downside of using this technique and how the behavior of the logreader can be "tweaked" to make using non-continuous replication a little less of a headache.

5 (1)

2002-03-28

4,967 reads

Blogs

ASF 032: Jennifer Stirrup interview

By

Introduction Jennifer Stirrup is a data strategist and technologist, Microsoft Data Platform Most Valuable...

SQL Server Express Size Limit

By

My Pluralsight course for new SQL Server DBAs   (Needs to upgrade to a...

Daily Coping 2 Jul 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Adding NOT NULL to column with existing rows causes page bloat

By timoq

Hi, I'd like to know why the page count is almost exactly doubled for...

Stretch database

By mtz676

Is there anything similar to a stretch database in mysql where an on-premise mysql...

Partitioning Heaps

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Partitioning Heaps

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers