Can someone shed some light to my problem here with the SQL Server cluster merge 100% CPU utilization during the merge replication for about 2-3 days consecutively ?
Here is the specification for the 2x Clustered VM in each sites:
2x Database Servers
Windows Server 2008 R2 Enterprise SP1
SQL Server 2008 R2 Enterprise SP1
16 GB vRAM
OS C:\ 60 GB HDD RAID 1
DATABASE D:\ 800 GB HDD RAID 5
LOGS L:\ 400 GB HDD RAID 5
QUORUM Q:\ 4 GB RAID 5
DTC T:\ 4 GB RAID 5
SNAPSHOT S:\ 500GB
2x vNIC (LAN and Heart Beat)
My question is that do I need to upgrade the above spec to lower down the CPU usage or change the replication schedule to be as often as possible like every 2 hours rather than weekly over the weekend ?