I have set up a merge publication and a subscriber with push subscription mode.

On the subscriber, I notice the CPU usage is going high periodically.

enter image description here

It may take about 40 seconds for the CPU Usage come back to 0%. And it occurs at same time as long as the Synchronization Status display : "Uploading data changes to the Publisher". This only occurs at subscriber, the publisher is normally.

I've go to Reports > Top Queries by Total CPU time at the subscriber to see which queries make the CPU usage go high and below is the result:

enter image description here

I don't know what to do next to fix this issue. Does anybody have an idea on how to solve it?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.