Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Cluster Update KB2710487 CPU Increase Expand / Collapse
Author
Message
Posted Friday, February 1, 2013 9:35 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 12:55 PM
Points: 9, Visits: 174
This is an interesting one.

Windows 2008r2SP1 EE
SQL 2008r2SP2CU1 EE


We have installed Cluster Service Update KB 2710487, which is supposed to fix inexplicable Cluster Service crashes with error 1359.

"The cluster service encountered an unexpected problem and will be shut down. The error code was '1359'"

The problem is that the Update increases CPU consumption a great deal. We've identified some interesting behavior:
• Install the patch on one Node, reboot the Node. CPU is normal (0) until you move a cluster group to that node
• With each Cluster Group Move a 1.25% increase in CPU is added to the Node, and it persists. Forever. Note that these are dedicated Nodes, and SQL Groups are complete inactive (no users, no databases)
• This CPU increase persists even after all Cluster Groups are moved off the Node
• 3 processes clearly account for the total CPU increase. When comparing these processes to non-updated hosts we found each of their CPU usage has clearly increased, and each are in constant use. On non-patched hosts all 3 processes have little CPU usage, and are in use infrequently. Here's some metrics:

PROCESSES ON A NON-UPDATED NODE
Process CPU Frequency
------------------ --------- ------------------------------
Clussvc 1 Frequent but not steady
lssas 0 infrequent
Wmiprvse 0 infrequent
---
1 Total Avg CPU

PROCESSES ON AN UPDATED NODE
Process CPU Frequency
------------------ --------- ------------------------------
Clussvc 10 Constant
lssas 2 Constant
Wmiprvse 1 Constant
---
13 Total Avg CPU

• When a workload is placed on the Cluster Node, CPU consumption of these 3 processes increases. The worst we're seeing is a 15% CPU increase on each node, where each Node is hosting 4 active SQL Groups. The inactive Node in this Cluster has a steady 5% CPU load. It is hosting 4 SQL Groups with activity.
• CPU usage patterns by these 3 processes on Updated Nodes are the same regardless of Node CPU and Memory resources

MS tried to argue that this was not a significant increase... riiiiiiiiight. So after days and days of data collection and arguing with support, they've finally agreed this is a bug, and it will be fixed.

Unfortunately this is as far as we've gotten. We have no root cause, or time frame for the fix. We badly need to fix this 1359 error, but we can't afford a 15% increase in CPU.

One thing we've found is that Clusters with Updated Nodes have overly verbose Heartbeat chatter:

Cluster Update Status Packet/Sec
--------------------------- ----------------
0 of 5 nodes Updated 2572
1 of 2 nodes Updated 5795
2 of 2 nodes Updated 12008
4 of 4 nodes Updated 18865

Have any of you seen this issue or have thoughts on HB chattiness being a root cause for CPU load increase?
Post #1414738
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse