New version of SQL source control extremely slow and hangs!

• 
  Hi @Prits,
  
  Can you confirm the full version number of your SQL Source Control and SSMS? Can you change the log level to All , reproduce the issue and attach the log file?

  Tianjiao_Li November 27, 2017 15:33

  - 0 +
• 
  Any update on this one? Facing the same performance issues. As soon as I uninstall SQL source control, SSMS runs fast as usual but when installing again ... extremely slow again.
  
  Thanks, Alexander

  faulandcc January 18, 2018 12:28

  - 0 +
• 
  Hi, I did not get a notification from Nov 27. But our company is still facing this issue. Almost making us give up Source control.
  I will try to confirm full version number later next week.

  Prits January 18, 2018 12:33

  - 0 +
• 
  similar problem, ours started taking forever on "Scripting changes to database comparison options" sometime after switching to version 6.0.2.6908. it does finish eventually, but takes so long compared to how it used to.

  clemsontiger March 23, 2018 13:05

  - 0 +
• 
  Sorry for the issue you are experiencing.
  
  It may be worth raising the amount of RAM for SSMS ( as a 32-bit application it can only access a maximum of 2GB RAM - even if the system it's running on is 64-bit.) by using the Large Address Aware utility on ssms.exe (see https://www.techpowerup.com/forums/threads/large-address-aware.112556/)
  
  There are few other things may also help:
  
  1- Try not to link large static data tables. https://documentation.red-gate.com/soc6/common-tasks/link-static-data
  
  2- Source Control decrypts encrypted objects by default- and sometimes the decryption causes Source Control to take a long time, please make sure uncheck this option if you don't have encrypted objects.(SQL Source Control - Setup - Comparison Options - Decrypt encrypted objects)
  
  3-Change the temp folder path so that it has enough space.
  
  4- Try unceck the last two options:
  
  

  Tianjiao_Li March 30, 2018 11:19

  - 0 +
• 
  We experience the same issue as clemsontiger whereby right-clicking objects in an attempt to get to the "Script As" menu is dreadfully slow (takes 30secs+ to get a context menu to appear).  Tianjiao_Li's suggestion doesn't help and so we disable SQL Source Control and then it's fine
  
  

  JoelMansord April 27, 2018 12:44

  - 0 +
• 
  Hi @JoelMansord
  
  Thanks for your post. 
  
  This looks like an engineer needs to investigate this for you so it would be great if you could send us a ticket if you have a support contract with us. 
  
  Kind regards
  
  Richard Lynch. 

  RichardL April 27, 2018 13:41

  - 0 +
• 
  Is there any update on this issue? It would seem it is still prevalent?

  jpelczynski December 20, 2019 19:39

  - 0 +

Add comment

Please sign in to leave a comment.