SQL Server 2008 - Performance impact of transactional replication?
- by cxfx
I'm planning to set up transactional replication for a 100Gb SQL Server 2008 database. I have the distributor and publisher on the same server, and am using push subscription.
Should there be a performance impact on my publisher server when it creates the initial snapshot, and synchronises it with a subscriber? From what I've tried so far on a staging server, it seems to slow right down.
Is there a better way to create the initial snapshot without impacting my production publisher server?