New version of SQL source control extremely slow and hangs!

Prits

Hi,

I have recently updated my SQL source control to SQL Source Control 6 and it's extremely slow.
When I link database to a GIT folder it ran for 15 minutes and hanged my SSMS, I needed to uninstall it to continue with my work.
I can see from the log file it took 7 minutes to perform [Creating new GitRecentFoldersStore]. Is this going to be a ongoing issue or would it get faster over time?

Thanks,
Prits

Tianjiao_Li

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?

faulandcc

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

Prits

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.

clemsontiger

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.

Tianjiao_Li

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:

JoelMansord

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

RichardL

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. 

jpelczynski

Is there any update on this issue? It would seem it is still prevalent?