<div>
Hi MohammedU,<br />
<br />
Does that affects just one instance or the whole cluster servers ?
</div>


Hi MohammedU,

Does that affects just one instance or the whole cluster servers ?

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
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 ?<br />
<br />
Here is the specification for the 2x Clustered VM in each sites:<br />
2x Database Servers<br />
Windows Server 2008 R2 Enterprise SP1<br />
SQL Server 2008 R2 Enterprise SP1<br />
4x vCPU<br />
16 GB vRAM<br />
OS C:\ 60 GB HDD RAID 1<br />
DATABASE D:\ 800 GB HDD RAID 5<br />
LOGS L:\ 400 GB HDD RAID 5<br />
QUORUM Q:\ 4 GB RAID 5<br />
DTC T:\ 4 GB RAID 5<br />
SNAPSHOT S:\ 500GB <br />
2x vNIC (LAN and Heart Beat)<br />
<br />
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 ?<br />

</div>
</div>


Hi,

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
4x vCPU
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 ?


SQL Server cluster merge 100% CPU utilization during the merge replication

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.