SCOM SQL MP 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….
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.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:

My good friend Marnix also blogged about it

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.



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 *