Friday, March 9, 2012

Replication & Reindex

I've read some varying opinions on this topic...
Is it a best practice to stop replicating a database during a maintenance window that is doing reindexing?
What is the effect of stopping / not stopping the distribution agent?
JUDE
I always prefer to avoid these jobs running concurrently. We reindex once a week so it's not too much of a big deal. The reason I separate the executions is to avoid blocking issues which will generally fail one of the jobs.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||The merge replication metadata tables in SQL 2000 get highly fragmented. You should defragement them which is an online operation (minimal locking). If you do see this interfering with replication processing you might want to stop the jobs, but it should not be necessary.
Hilary Cotter
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
"Jude" <judes@.email.uophx.edu> wrote in message news:%23o2Cx8ODHHA.4952@.TK2MSFTNGP06.phx.gbl...
I've read some varying opinions on this topic...
Is it a best practice to stop replicating a database during a maintenance window that is doing reindexing?
What is the effect of stopping / not stopping the distribution agent?
JUDE
|||JUDE
"Jude" <judes@.email.uophx.edu> wrote in message news:%23o2Cx8ODHHA.4952@.TK2MSFTNGP06.phx.gbl...
I've read some varying opinions on this topic...
Is it a best practice to stop replicating a database during a maintenance window that is doing reindexing?
What is the effect of stopping / not stopping the distribution agent?
JUDE

No comments:

Post a Comment