SQL Source Control is running too slow

Purpose

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. This memory limit can result in slow performance when working with larger databases.

You can raise the memory maximum to 4GB by making SSMS large address aware. Please update to SSMS v17.3 or above which is large address aware by default, 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/.

Steps

In case making SSMS large address aware does not help:

  • Upgrade to the latest version of SQL Source Control.

  • 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.
Was this article helpful?

3 out of 10 found this helpful
Have more questions? Submit a request