How can we help you today? How can we help you today?

Has anyone else been experiencing severe performance issues with SQL Source Control & SSMS?

It seems for the past month I have encountered, almost on a daily basis, instances where SSMS has slowed down to a halt. Sometimes it also crashes and it tries to send an error report to Redgate. The only thing I can point to is SQL source control as it's trying to fetch the latest changes from a database. I've noticed performance issues when opening SQL test too.

In addition, I also get frequent out of memory exceptions in SSMS when running queries, and I'm wondering if it could be redgate related. When this happens, I noticed that often I'm not even running an expensive query. It just seems to happen after I have been running SSMS for some time, and then I have to restart SSMS.

SSMS 2017
SQL Server 2014
SQL Source Control 6.0.2.6908
SQL Test 2.0.1.261
kakins-tamus
0

Comments

3 comments

Sort by
  • Tianjiao_Li
    Hi @kakins-tamus

    Sorry to hear you are having this issue.

    Can you upgrade to the latest version and test again?

    Here are few things you can try:
    1- Check this page
    2- Try unceck the last two options:


    Tianjiao_Li
    0
  • ryan_p
    I have been experiencing these same issues ... and when I try to click Options I get a "not set to the instance of an object" error.  I have Reported the Issue.  I am on the most recent version.  Is there anything else I can try?

    Also, I have tried making ssms Large Address Aware but that has not helped.  I am on 64 bit Windows.
    ryan_p
    0
  • luckymcg82
    I am setting up the trial version and having a rough time with source control. I was able to successfully link my database to our TFS, but havent been able to even begin testing source control because my SSMS crashes everytime i pull up the commit page. I am not receiving a Sustem. OutOfMemoryException  error. 

    I used RedGate Source control at a previous job with GIT and had no issues.
    luckymcg82
    0

Add comment

Please sign in to leave a comment.