Skip Ribbon Commands
Skip to main content
SharePoint

Markus' Blog

Dec 03
Why you should use a really old SQL Compatibility Level for your SP2016 databases

You might know, that the support policy for SharePoint and SQL Server has always been

N, N-1, N+1

That means that for SharePoint 2016 the supported versions of SQL Server are SQL 2016 (N), SQL 2014 (N-1) and SQL 2017 (N+1) – which means a database compatibility level of 12 or higher. But when reading this knowledgebase article and Stefan Gossner's blog, it turns out, that selecting a database compatibility level of 11 (SQL Server 2012) is beneficial for the performance of the SharePoint farm. Compatibility Level 11 it is!

 

Body
  
Great
1/28/2019 1:42 PM

Comments

There are no comments for this post.

 

About me...

About this blog

                                
My thoughts and findings about SharePoint 2016/2013/2010 and SQL Server

 

Markus Hintner
MCM_2013(rgb)_1406.jpg

MCSM_2013(rgb)_1543.jpg