Concurrent Snapshot Processing???

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BATMAN - 28 Oct 2006 22:20 GMT

Other than the following constraints on "Concurrent Snapshot Processing", is
there any reason NOT to check the "Concurrent access durning snapshot
generation" option?

Known Constraints:
--Must run log reader agent after snapshot generation
--Primary key or unique constraint must be contained in clust index

Thanks,

Michael

Thanks,

MIchael

Reply to this Message

Hilary Cotter - 30 Oct 2006 02:27 GMT

It takes longer to generate the snapshot. In some cases this makes the
decision to use concurrent snapshots a poor one.

Signature

Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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

> Other than the following constraints on "Concurrent Snapshot Processing",
> is
[quoted text clipped - 12 lines]
>
> MIchael

Reply to this Message