SCOM 2012 R2 and SQL Server 2014

**** This is not supported by Microsoft and should only be done in a Test Environment ****

*** Not even in the staging environment – Please ***

Some customers have asked me about the gain for using SQL 2014 in the SCOM environment – And I did some fast tests – In my test envronment (7 servers, NLB, 2 MS, 2 Web/Report) which shows that out-of-the-box it will actually be faster just to upgrade to SQL 2014. And both an Upgrade and New Install does work with SCOM 2012 R2.

Configuration:

  • Virtual Machine:
  • 4 gb memory
  • VHD on SSD drive

I have done some SQL scripting I use for performance testing – which return the average wait for the individual database:

Before the upgrade – SQL 2012:

image

 

After the Upgrade – SQL 2014:

image

 

I really tried to provoke it in 2014 – And its looks very stable the Operations Manager Console and the new Widgets seams to work a bit faster but Reporting are the same.

Please wait until Microsoft Supports SQL 2014 which will be in the next Update Release in a month.

Have a great day

By | 2014-05-15T15:54:26+00:00 May 15th, 2014|Operations Manager (SCOM), SQL|2 Comments

About the Author:

Kåre Rude Andersen
Microsoft Certified Trainer since 1996, MCSE, TS and ITP in Microsoft Windows, SQL (also Microsoft), Exchange (MS) and Microsoft Operations Manager. Senior Consultant and have recently worked as a consultant at CSC, SAS, ISS, Nokia and Scandlines.

2 Comments

  1. Kåre Rude Andersen August 18, 2014 at 8:52 - Reply

    UPDATE – SQL 2014 is still not official supported by Microsoft, perhaps we need to wait until RU4?

    see you
    Kåre

  2. cloud clip arts September 10, 2017 at 23:14 - Reply

    … [Trackback]

    […] Find More here|Find More|Read More Infos here|There you can find 75604 more Infos|Informations on that Topic: blog.ctglobalservices.com/operations-manager-scom/kra/scom-2012-r2-and-sql-server-2014/ […]

Leave A Comment