Version 3.6.6.178 is REALLY slow

Ozzie · June 4, 2014 8:22AM

Source Control prompted me to update to 3.6.6.178 - and ever since Source Control is dog slow.

I see a Tweet for 3.6.7 - but it doesn't get pulled down by the 'Check for Updates' link on the Source Control help tab?

Help

Ozzie · June 4, 2014 9:54AM

I downloaded the other tool and obtained 3.7.7.246 - but the problem remains.

I takes an excessive amount of time for SQL to open and close when connected via Source Control. If I launch another instance not under source control things open and close immediately, if that is of any help.

I also do notice when I clicked the check for update it took almost 45 seconds for it to come back with no updates available.

Evan Moss · June 6, 2014 2:21PM

Hello,

Thanks for your post and sorry you're experiencing issues.

Would you mind sending in your log file to us at support@red-gate.com?

If you could turn the logging up first, that would be great. To do this, follow the steps in this document: http://documentation.red-gate.com/displ ... +log+files

Your EngineOptions file should look like this:

&lt;EngineOptions version="3" type="EngineOptions"&gt;
  &lt;LogLevel&gt;All&lt;/LogLevel&gt;
&lt;/EngineOptions&gt;

Once you have the logging turned up, please open SSMS and re-create the behavior that causes poor performance, then close SSMS. That should generate a log file that you can send over. It will be located in "%userprofile%\AppData\Local\Red Gate\Logs\SQL Source Control 3"

We have a ticket open for you (21056), which you should have gotten an email for, so please respond to that.

Thanks,
Evan

Ozzie · June 9, 2014 5:41PM

I have now done that - my config file now looks like this

&lt;?xml version="1.0" encoding="utf-8" standalone="yes"?&gt;
&lt;!----&gt;
&lt;EngineOptions version="3" type="EngineOptions"&gt;
  &lt;DefaultTraceMinimumInterQueryTimeInMillis&gt;900000&lt;/DefaultTraceMinimumInterQueryTimeInMillis&gt;
  &lt;TraceCacheDatabase&gt;ChangeLog&lt;/TraceCacheDatabase&gt;
  &lt;AllowMultipleSsms&gt;True&lt;/AllowMultipleSsms&gt;
  &lt;LogLevel&gt;All&lt;/LogLevel&gt;
&lt;/EngineOptions&gt;

Evan Moss · June 9, 2014 5:48PM

Hello,

I've contacted you through our support system. Can you send your log file there?

Thanks,
Evan

Bellisio · June 11, 2014 1:00PM

Hi, I'm having the same slowness with this version as well. Am running multi-SSMS as is this customer, and I am still on TFS2008. It takes forever to pull up the Commit Changes results, even when few or none. Also takes forever just opening the tables tree or stored proc tree. If you figure out a solution, I'd be happy to try it myself, thanks.
Bev

Ozzie · June 12, 2014 11:09AM

Evan,

Clicked on and downloaded the new product - Top marks on the new version - everything syncs up practically instantaneously, versus a minute plus with the older version when rendering the stored procedures.

Thank you so much!
Doug 8)

Bellisio · June 12, 2014 11:23AM

good news, Evan will this version be available for all soon?

cguanes · June 12, 2014 1:59PM

I'm having the same problem, I uninstalled all SQL tools, the SQL management and after installing back one-to-one I found the issue was the Source Control 3.6.6.178.

The slowness was killing me all week but I was busy to research the cause of it.

When the new version mentioned by Ozzie will be public, or how can we download it as beta?

Thank you.[/quote]

bslatner · June 12, 2014 6:18PM

I'm having the exact same problem. SQL Management Studio is completely unusable with the 3.6.6.178 version installed.

Any ideas when the fix will be available?

shawnC · June 13, 2014 3:15AM

We have a team of 15 developers all using SQL Source Control, all on the latest version to fix the "dbo schema" errors.

The software is killing our servers: people are unable to check in

When is this update due please? Where can we get the file mentioned above?

daveh0ward · June 13, 2014 9:52AM

Having the same problem described.
On version 3.7.7.246 and it is painfully, unusably slow. Please advise asap.

GrahamH · June 16, 2014 10:09AM

Here's a link to a frequent update* we believe fixes the issue. Please do let us know whether the issue is resolved:
http://download.red-gate.com/checkforupdates/SQLSourceControlFrequentUpdate/SQLSourceControlFrequentUpdate_3.6.8.222.exe

*More about what "frequent update" means here: http://www.red-gate.com/products/sql-development/sql-source-control/frequent-updates

cguanes · June 16, 2014 10:15AM

I just installed the version 3.6.8.222 from your link above and it is working back on speed.

Thank you.

GrahamH · June 16, 2014 10:18AM

Glad to hear it's working Carlos

acrawford · June 16, 2014 10:32AM

Yes 3.6.8.222 is so much better.....back to normal as far as speed is concerned. Thanks!

daveh0ward · June 16, 2014 11:41AM

It's working for me as well, thank you!

bslatner · June 16, 2014 3:06PM

Working for me as well. Back to normal.

Bellisio · June 16, 2014 3:16PM

works here too. Thank you.

Ozzie · June 19, 2014 10:14AM

Speed is even better than before - thanks for all of your help!

Doug

Version 3.6.6.178 is REALLY slow

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk