SQL Source Control is running too slow

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/.

In case making SSMS large address aware does not help:

  

  • 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.

If none of the above helps, we advise taking a look at Flyway Desktop which is now the successor to SQL Source Control. It operates independently to SSMS thus avoiding all of the performance bottlenecks: https://documentation.red-gate.com/fd

 

Was this article helpful?

4 out of 17 found this helpful
Have more questions? Submit a request