Fix: SQL server hits 100% CPU utilization when there are configuration update requests in SCOM 2007

Toolbox3When using SQL Server 2008 R2 as the database server for the System Center Operations Manager 2007 operationsmanager database, the SQL server service may use 100% CPU when SCOM 2007 triggers configuration update requests. For example, when we make a change to a rule/monitor, or modify some override values, the SQL server service will use 100% CPU utilization. This high CPU usage will persist for several minutes. The affecting time is based on how many configuration updates will be raised after the console changes. During the period that the SQL server service is hitting 100% CPU, the SCOM administration console will also be unresponsive.


While the Operations Manager database is preparing for requested configuration updates, there will be a lot of accesses to the tempdb database. If you used a Run As account that is not in sysadmin group, a known issue with SQL 2008 R2 will be encountered. From the SQL server side, this issue occurs because of high spinlock contentions on security caches when a non-sysadmin user creates a heavy OLTP workload on the tempdb database.


This SQL issue was first fixed in SQL Server 2008 R2 Cumulative Update 5 (CU5):;en-US;2438347

The SQL hotfix avoids regenerating a security token when a temporary object is either explicitly or implicitly dropped by a non-sysadmin user, therefore the high spinlock contentions do not occur again.

More Information

As a best practice, we need to apply SQL 2008 R2 CU5 before we upgrade the SCOM operations manager database to SQL 2008 R2.

Simon Xin | Support Escalation Engineer

The App-V Team blog:
The WSUS Support Team blog:
The SCMDM Support Team blog:
The ConfigMgr Support Team blog:
The SCOM 2007 Support Team blog:
The SCVMM Team blog:
The MED-V Team blog:
The DPM Team blog:
The OOB Support Team blog:
The Opalis Team blog:
The Service Manager Team blog: http:
The AVIcode Team blog: http:

clip_image001 clip_image002

Comments (3)

  1. brad says:

    Is there a way that we can demonstrate this issue so that once the CU has been applied, the same test will not show high cpu usage?

  2. Christian Alcouce says:

    Hi, i also found that setting SQL Max Worker Threads to 576 (for my case 8cpu 64 bits) solved the problem.

  3. show box says:

    Thanks for the great info. I really loved this. I would like to apprentice at the same time as you amend your web site, how could i subscribe for a blog site?
    For more info on showbox please refer below sites:
    Latest version of Showbox App download for all android smart phones and tablets. – It’s just 2 MB file you can easily get it on your android device without much trouble. Showbox app was well designed application for android to watch movies and TV shows, Cartoons and many more such things on your smartphone.
    For showbox on iOS (iPhone/iPad), please read below articles:
    Showbox for PC articles:
    There are countless for PC clients as it is essentially easy to understand, simple to introduce, gives continuous administration, effectively reasonable. it is accessible at completely free of expense i.e., there will be no establishment charges and after establishment
    it doesn’t charge cash for watching films and recordings. Not simply watching, it likewise offers alternative to download recordings and motion pictures. The accompanying are the strides that are to be taken after to introduce Showbox application on Android. The above
    all else thing to be done is, go to the Security Settings on your Android telephone, Scroll down and tap on ‘Obscure sources’.
    Movie Box, an esteemed movies application in which you can find stacks of programs and films. The guide is given here to download Movie Box app to Android and to Apple iOS 9.0.2, iOS 8.4/8.3 and also for the lower versions without Jailbreak.
    Please do login to Showbox application with the help of Ymail. You can login in Ymail from here –
    Sign Up & Do registration for latest movies on Showbox application