Kevin Holman's System Center Blog

Posts in this blog are provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified in the Terms of UseAre you interested in having a dedicated engineer that will be your Mic

If you are using SQL 2008 R2 for OpsMgr DB’s, you need SQL 2008R2 CU5

If you are using SQL 2008 R2 for OpsMgr DB’s, you need SQL 2008R2 CU5

  • Comments 2
  • Likes

 

There is an issue where your SQL server hosting the OperationsManager database might consume large amounts of CPU for extended periods. 

This is due to a security cache issue when a non-sysadmin creates a heavy workload on a TempDB database.  Read more about this on the support team blog:

http://blogs.technet.com/b/operationsmgr/archive/2011/02/03/fix-sql-server-hits-100-cpu-utilization-when-there-are-configuration-update-requests-in-scom-2007.aspx

 

 

This SQL issue was first fixed in SQL Server 2008 R2 Cumulative Update 5 (CU5):

http://support.microsoft.com/default.aspx?scid=kb;en-US;2438347

Comments
  • Thanks again Kevin for a great post,

    We are about to install SCOM 2007 R2 CU4 and then upgrade to SQL 2008 R2 (currently on SQL 2008 SP2).

    We could not do an inplace upgrade from SQL 2008 SP2 to SQL 2008 R2 when running SCOM 2007 R2 CU3 as the pre-requisit failed. We then saw a post of ours that said this upgrade failure should be resolved in SCOM 2007 R2 CU4

    Thanks for the above, info your blog on SCOM is one of the very best on the internet

    Ernie

  • Thank you a lot for that info. I can really recommend this update. Our OpsMgr DB is running on a server with 16 cores, so it was never max out but it was running with an average of 10% - after we applied the CU5 it dropped to and average of 5%...so that is really nice.

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment
Search Blogs