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


Comments (%):

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

    see you
    Kåre

Leave a Reply