Groups | Blog | Home
all groups > sql server replication > may 2007 >

sql server replication : SQL 2005 Server S-L-O-W after starting Merge Replication


Stewart Saathoff
5/12/2007 2:44:59 PM
Hello,

I have a Server with 4GB of RAM and 2 64-Bit Intel Xeon Processors. I have
about 400 GB of Free Hard Disk Space on a RAID 5 SCSI Hard Disk.

I am attempting to do snapshot replication to a remote server. Every time
that I start the job, the server goes to a crawl. There are no indications
that there is anything wrong spec wise. I started the task manager and
there is only 1.9 GB of RAM used and little Processor utilization.

When replication begins, the Replication monitor shows that it get to 89% in
the staging step and then the server goes down to its knees. The database is
13GB in size...

Does anyone know what I can do to fix this?

Regards,
Stewart

Paul Ibison
5/14/2007 12:00:00 AM
Have you checked for any locking issues (sp_who2)? A 13GB database is quite
big - how much of it is being replicated - if it is a significant amount,
then I would not go through the normal snapshot mechanism out of choice -
better to use a backup and restore method of initialization.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

AddThis Social Bookmark Button