Symptom
The MSSQL Server is upgraded to a higher version and the database compatibility level remains on a lower version.
Reproducing the issue
Prerequisites:
You have upgraded MSSQL Server to a higher version.
Scenario:
The database compatibility level is not aligned with the version of MSSQL Server.
Expected behavior:
The database compatibility level is upgraded automatically after the upgrade of MSSQL Server.
Actual behavior:
The database compatibility level is not upgraded automatically after the upgrade of MSSQL Server, only in certain upgrade paths. It may potentially lead to performance issues, especially when you are using an outdated compatibility level.
Cause
System behavior
Solution
Align the compatibility level for company database with the MS SQL Server Default Compatibility Level Designation in Management Studio. Navigate to the Database Properties / Options / Compatibility level dropdown menu and select required value.