November 22, 2004 at 9:24 am
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
November 22, 2004 at 3:54 pm
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply