Hi,
We have a dedicated Distribution server with transactional replication.
We are seeing CPU usage going up to 100% and latency build up slowly.
As soon as we reboot the distribution server CPU will go down and replication latency will come down dramatically.
When we do sp_who2 active there are lot of SELECT's sitting around consuming lot of CPU.
If you guys facing this kind of situation - please let me know what was the fix..
Thanks in advance.