Version 3.6.6.178 is REALLY slow

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace, andy.campbell.smith

Version 3.6.6.178 is REALLY slow

Postby Ozzie » Wed Jun 04, 2014 1:22 pm

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
 
Posts: 18
Joined: Tue Jun 26, 2007 9:10 pm
Location: Havertown, PA, USA

Postby Ozzie » Wed Jun 04, 2014 2:54 pm

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.
Ozzie
 
Posts: 18
Joined: Tue Jun 26, 2007 9:10 pm
Location: Havertown, PA, USA

Postby Evan Moss » Fri Jun 06, 2014 7:21 pm

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:

Code: Select all
<EngineOptions version="3" type="EngineOptions">
  <LogLevel>All</LogLevel>
</EngineOptions>


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
Evan Moss
Product Support
(866) 627-8107
Evan Moss
 
Posts: 99
Joined: Wed Jun 12, 2013 9:56 pm

Postby Ozzie » Mon Jun 09, 2014 10:41 pm

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

Code: Select all
<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<!---->
<EngineOptions version="3" type="EngineOptions">
  <DefaultTraceMinimumInterQueryTimeInMillis>900000</DefaultTraceMinimumInterQueryTimeInMillis>
  <TraceCacheDatabase>ChangeLog</TraceCacheDatabase>
  <AllowMultipleSsms>True</AllowMultipleSsms>
  <LogLevel>All</LogLevel>
</EngineOptions>
Ozzie
 
Posts: 18
Joined: Tue Jun 26, 2007 9:10 pm
Location: Havertown, PA, USA

Postby Evan Moss » Mon Jun 09, 2014 10:48 pm

Hello,

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

Thanks,
Evan
Evan Moss
Product Support
(866) 627-8107
Evan Moss
 
Posts: 99
Joined: Wed Jun 12, 2013 9:56 pm

Postby Bellisio » Wed Jun 11, 2014 6:00 pm

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
Bellisio
 
Posts: 19
Joined: Wed Oct 29, 2008 8:09 pm
Location: State of CT - DDS

The newer version rocks!

Postby Ozzie » Thu Jun 12, 2014 4:09 pm

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)
Ozzie
 
Posts: 18
Joined: Tue Jun 26, 2007 9:10 pm
Location: Havertown, PA, USA

Postby Bellisio » Thu Jun 12, 2014 4:23 pm

good news, Evan will this version be available for all soon?
Bellisio
 
Posts: 19
Joined: Wed Oct 29, 2008 8:09 pm
Location: State of CT - DDS

Slowness 3.6.6.178

Postby cguanes » Thu Jun 12, 2014 6:59 pm

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]
Carlos Guanes
cguanes
 
Posts: 8
Joined: Wed Feb 08, 2012 12:28 am

Having the exact same problem

Postby bslatner » Thu Jun 12, 2014 11:18 pm

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?
bslatner
 
Posts: 2
Joined: Thu Jun 12, 2014 11:16 pm

Postby shawnC » Fri Jun 13, 2014 8:15 am

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?
shawnC
 
Posts: 13
Joined: Tue Nov 22, 2011 1:53 pm

Postby daveh0ward » Fri Jun 13, 2014 2:52 pm

Having the same problem described.
On version 3.7.7.246 and it is painfully, unusably slow. Please advise asap.
daveh0ward
 
Posts: 2
Joined: Fri Jun 13, 2014 2:49 pm

Frequent Update release

Postby GrahamH » Mon Jun 16, 2014 3:09 pm

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
GrahamH
 
Posts: 6
Joined: Mon Jul 05, 2010 10:59 am

it is working back

Postby cguanes » Mon Jun 16, 2014 3:15 pm

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

Thank you.
Carlos Guanes
cguanes
 
Posts: 8
Joined: Wed Feb 08, 2012 12:28 am

Postby GrahamH » Mon Jun 16, 2014 3:18 pm

Glad to hear it's working Carlos :)
GrahamH
 
Posts: 6
Joined: Mon Jul 05, 2010 10:59 am

Next

Return to SQL Source Control 3

Who is online

Users browsing this forum: Yahoo [Bot] and 1 guest