Home > Forum > Database > Experience with updated Database Compatibility Level

Experience with updated Database Compatibility Level
1

MVP

I'm not a DB Admin and I'm more interested in the available function but it seems that the compatibility level also effects the performance as of SQL Server 2014 (120).
https://www.sqlskills.com/blogs/glenn/database-compatibility-level-in-sql-server/

Migrating an existing database to a new server may result in some performance increase but without an updated compatibility level you won't take full use of it.
This applies to the major part of database usages. There may be cases where there is a drop in performance, so it needs to be tested:
https://docs.microsoft.com/en-us/sql/database-engine/install-windows/change-the-database-compatibility-mode-and-use-the-query-store

Did someone go through this already?

Best regards
Daniel

MVP

It seems, that someone updated the database compatibility level.

From Changelog 2022.1.2.31
https://community.webcon.com/download/changelog/106?q=b6419bb
Fixed a problem with query performance e.g. in reports. The error occurred if the compatibility level in SQL databases (SQL 2019) was equal to 150.

Could be a hint, that updating the compatibility level is an option.

MVP
In reply to: Daniel Krüger (Cosmo Consult)

It seems, that someone updated the database compatibility level.

From Changelog 2022.1.2.31
https://community.webcon.com/download/changelog/106?q=b6419bb
Fixed a problem with query performance e.g. in reports. The error occurred if the compatibility level in SQL databases (SQL 2019) was equal to 150.

Could be a hint, that updating the compatibility level is an option.

At least for WEBCON BPS 2022 we have an official answer. :)

https://community.webcon.com/posts/post/webcon-bps-databases-in-the-sql-2019-compatibility-level/320
From WEBCON BPS 2022.1.1, the lowest supported SQL Server is 2014.

In the case of WEBCON BPS installations using the higher versions of SQL Server, WEBCON BPS databases work with the compatibility level set to SQL Server 2014 by default.