**** 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:
After the Upgrade – SQL 2014:
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
UPDATE – SQL 2014 is still not official supported by Microsoft, perhaps we need to wait until RU4?
see you
Kåre
… [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/ […]