locked
Clustering environment: High CPU Usage RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Guys,

    we are running 3 nodes and 8 sql server instances on each node, the node a gets crazy on cpu usage(90%~100%) every 10 minutes, there is no scheduled task or reporting running on this timing basis, observing the task manager, the clussvc.exe is up to 20%~23% when cpu is 90~100%, by windows performance analyser, found out rpcrt4.dll cause lot of cpu usag, also the resource monitor shows lots cluster api calls/sec and group api calls/sec; messages sent/sec is high in Cluster Multicast Request Response Messages section; no doubt many bytes coming through and out in Cluster Network Messagess section.

    Is there a way to find out what cause the cpu high usage issue?

    We are using windows server 2012 R2, ram is big enough.

    Regards,

    Nicolas

    Wednesday, October 29, 2014 6:50 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Might also want to ask in the SQL forum.

    Physical or virtual SQL instances?  Any memory constraints on SQL usage?  What does memory utilization look like?  (Notice these are really SQL questions)

    . : | : . : | : . tim

    • Proposed as answer by Alex Lv Tuesday, November 4, 2014 11:38 AM
    • Marked as answer by Alex Lv Monday, November 10, 2014 8:27 AM
    Wednesday, October 29, 2014 11:18 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    Found something in event log, but it doesn't seemed to related to the high cpu usage issue.

    Clusapi (0): ApiQueryValue exited with cluster_error = 234, rpc_error = 0

    Clusapi (0): calling RESOURCE CONTROL with function number 29

    Clusapi (0): calling RESOURCE CONTROL with function number 2

    Clusapi (0): ApiEnumValue exited with cluster_error = 259, rpc_error = 0

    Wednesday, October 29, 2014 7:01 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Might also want to ask in the SQL forum.

    Physical or virtual SQL instances?  Any memory constraints on SQL usage?  What does memory utilization look like?  (Notice these are really SQL questions)

    . : | : . : | : . tim

    • Proposed as answer by Alex Lv Tuesday, November 4, 2014 11:38 AM
    • Marked as answer by Alex Lv Monday, November 10, 2014 8:27 AM
    Wednesday, October 29, 2014 11:18 PM