Replication Causing High CPU Usage

  • I have continuous transactional replication setup on a remote server.  It has been running fine, but SQL Server is now taking 100% of the CPU Usage.  I stop the replication jobs and the process goes back down.  But once replication is started again the CPU Usage shoots right back up.  The thing is that no transactions are being replicated while the heavy CPU Usage is occurring.  Does anyone have any suggestions to improve the performance.  This is what I have already done to improve the situation.

    **Installed more memory

    **Shrink Distribution Database logs

    The replication must be continuous.  I have considered having two servers distribute the data, but I can't figure out how to designate two distributors from the publishing server.  Is this possible, and if so is it a good idea?

    The amount of data being replicated is not very large, so I am at a loss for what to do.  Thank you for any assistance.

    Adam

  • It would be a good idea to find out just what Replication job/s are consuming 100% CPU. Either use Profiler or just do a sp_who in QA to list the "runnable" spids.

    Once you have established that, we can then ascertain much more.


    Kindest Regards,

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply