TN 1297 How to increase template check-in and deployment speed by changing the galaxy SQL Compatibility

Description

How to increase template check-in and deployment speed by changing the galaxy SQL Compatibility

• Author: Mike Viteri
• Published: 11/28/2022
• Applies to: System Platform 2020R2SP1 and Later

Details

Before making any changes make sure the IDE is closed and make a galaxy backup.

There has been situations where checking in templates or deploying objects have been slow in 2020R2SP1 and later.

To increase performance you can change the SQL Compatibility level. This can be change from SQL 2012(110) to the latest version you have.

This can be set by going into SQL Server Management Studio and right clicking on your galaxy database and selecting properties.

You will a popup like below. Select Options. Then you can see the default is SQL Server 2012(110). 

We can now click the Compatibility level drop down and select SQL 2019(150). You can only select the SQL Server version you have installed as the latest.

Click ok and close the SQL Management Studio. Now you can reopen IDE and should see an increase in performance in check-in and deployemnts.