Skip Ribbon Commands
Skip to main content

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!


There are no items to show in this view of the "Comments" list. To add a new item, click "New".


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