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

Steps

  

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

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