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

Experience with updated Database Compatibility Level
1

MVP

Hello everyone,

did someone update the database compatibility level from the default 'SQL Server 2008 (100)' to a newer one and can share their experience?

I really would like to make use of those "new" functions instead of using hard to read workarounds.

Best regards,
Daniel

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.

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

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.

A new knowledge base post has been added:
Quote:
"When installing BPS databases on SQL server higher than 2014, changing the Compatibility Level of WEBCON BPS databases from SQL Server 2014 to a higher level is not recommended."

https://community.webcon.com/posts/post/compatibility-level-of-webcon-bps-databases-good-practices/323