SSMS is a 32-bit application and as a result it can only access a maximum of 2GB RAM; even if the system it's running on is 64-bit. Please upgrade SSMS to v17.3 or above or raise the amount of RAM available by using the Large Address Aware utility on ssms.exe. See https://www.techpowerup.com/forums/threads/large-address-aware.112556/).
Try to avoid working against a remote database over a slow connection.
Try to avoid having lots of migration scripts. If this isn't possible, please consider switching to SQL Change Automation as it handles migration scripts better.
- Try to avoid linking large static data tables. https://documentation.red-gate.com/soc6/common-tasks/link-static-data
- Uncheck the last two options as shown, if possible:
- Ensure the Decrypt encrypted objects option is unchecked if it's not needed. Source Control decrypts encrypted objects by default, to change this go to SQL Source Control>Setup>Comparison Options>Decrypt encrypted objects.
- Unlinking and re-linking can help in the short term.