This article from InSource shows a possible resolution to slow IDE performance.
- Author: Peter Farrell
- Published: 03/17/2023
- Applies to: Application Server 2020 and above
If you are experiencing slow IDE performance or issues with the check-in of objects, one possible solution may be to match the actual SQL Server version installed to the Compatibility level configured for the Galaxy database that you are using. This is particularly relevant to Galaxies which have been upgraded with an accompanying SQL Server upgrade.
- You should be familiar with the use of Microsoft SQL Server Management Studio.
- You must be logged in as the sa account or an account with System Administrative privileges.
- Open SQL Server Management Studio.
- Click the button on the menu bar for “New Query”
- Enter the following query:
- Click the “Execute” button to run the query.
- The query result will be displayed beneath the Query pane and should display the version of SQL Server installed on the machine. Make a note of the version.
- Navigate to the Object Explorer pane on the left of SQL Server Management Studio.
- Expand Databases and locate the Galaxy Database for which you are experiencing performance issues. The example shown below is checking a Galaxy called Sandbox, but you should select your Galaxy database.
- Right click the Galaxy database and select “Properties”
- The selected Galaxy database Properties pane will display. Under the “Select a page” pane on the left click on “Options”
- Look at the “Compatibility Level” and ensure that the level selected matches the version returned above by the query Select @@version. If it does not match, you should select the matching version and click OK.
- Restart the SQL Server service from Services. Check the IDE to confirm the issue is resolved. If not, please contact the InSource Solution Technical Support group for further assistance.