SCOM SQL MP 6.6.2.0: 100% CPU, Logs Full, deployment failure ….

This morning at one of my customer, I decided to import the last version of the SQL Management pack, which is the 6.6.2.0….
After a few hours, we noticed some very strange behaviors that were happening in the SCOM environment.

  1. SCOM failed to deploy database component to Data Warehouse.
  2. The CPU on the SQL server hosting the SCOM Date Warehouse DB was running at 100%.
  3. If we take a look at the CPU usage for the last few days, we could see that something is going wrong since we imported the MP.
  4. The Data Warehouse DB Log file increased of several GB at once and continued to grow very quickly
  5. In SQL, we could see that one query was really CPU Intensive.
  6. If we look into the details, we could see that this is related to the SQLServer Virtualization Library.

  7. To fix the problem, just remove the followings MPs from the SCOM Management Console:
  • Microsoft.SQLServer.2014.Presentation.mp
  • Microsoft.SQLServer.2012.Presentation.mp
  • Microsoft.SQLServer.2008.Presentation.mp
  • Microsoft.SQLServer.Generic.Dashboards.mp
  • Microsoft.SQLServer.Visualization.Library.mpb

After a few minutes, you will directly see the CPU SQL of your SQL server will return to a normal situation J

There are already 2 threads on TechNet about this problem:
https://social.technet.microsoft.com/Forums/en-US/093752f2-ae08-42c3-92f7-3c31f45acef9/sql-2014-6620-filling-sql-dw-logs?forum=operationsmanagermgmtpacks
https://social.technet.microsoft.com/Forums/scriptcenter/en-US/a0f1ff51-791a-4231-a674-6905069356f3/sql-management-pack-6620-broken-visualizations?forum=operationsmanagermgmtpacks

My good friend Marnix also blogged about it
http://thoughtsonopsmgr.blogspot.be/2015/10/issue-with-sql-server-mp-version-6620.html

I had the confirmation that the product team is aware of the problem and they are currently working on a fix.

I’ll keep you posted as soon as I’ve got some news from Microsoft.

Christopher

 

Tweet about this on TwitterShare on FacebookShare on LinkedInShare on Google+Email this to someoneShare on TumblrPin on PinterestDigg thisShare on RedditFlattr the authorBuffer this pageShare on StumbleUpon

About Christopher Keyaert

Christopher Keyaert is a Consultant, focused on helping partners to leverage the System Center and Microsoft Azure cloud platform. He is also a Microsoft Most Valuable Professional (MVP) for Cloud and Data Center Management and a Microsoft Certified Trainer (MCT).
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *