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

Should making SSMS large address aware 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.
Was this article helpful?

1 out of 5 found this helpful
Have more questions? Submit a request