Red Gate forums :: View topic - Version 3.6.6.178 is REALLY slow
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 3
SQL Source Control 3 forum

Version 3.6.6.178 is REALLY slow

Search in SQL Source Control 3 forum
Post new topic   Reply to topic
Jump to:  
Go to page 1, 2  Next
Author Message
Ozzie



Joined: 26 Jun 2007
Posts: 18
Location: Havertown, PA, USA

PostPosted: Wed Jun 04, 2014 1:22 pm    Post subject: Version 3.6.6.178 is REALLY slow Reply with quote

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
Back to top
View user's profile Send private message
Ozzie



Joined: 26 Jun 2007
Posts: 18
Location: Havertown, PA, USA

PostPosted: Wed Jun 04, 2014 2:54 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Evan Moss



Joined: 12 Jun 2013
Posts: 99

PostPosted: Fri Jun 06, 2014 7:21 pm    Post subject: Reply with quote

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/display/SOC3/Logging+and+log+files

Your EngineOptions file should look like this:

Code:

<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
Back to top
View user's profile Send private message Send e-mail
Ozzie



Joined: 26 Jun 2007
Posts: 18
Location: Havertown, PA, USA

PostPosted: Mon Jun 09, 2014 10:41 pm    Post subject: Reply with quote

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

Code:
<?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>
Back to top
View user's profile Send private message
Evan Moss



Joined: 12 Jun 2013
Posts: 99

PostPosted: Mon Jun 09, 2014 10:48 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Bellisio



Joined: 29 Oct 2008
Posts: 19
Location: State of CT - DDS

PostPosted: Wed Jun 11, 2014 6:00 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Ozzie



Joined: 26 Jun 2007
Posts: 18
Location: Havertown, PA, USA

PostPosted: Thu Jun 12, 2014 4:09 pm    Post subject: The newer version rocks! Reply with quote

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 Cool
Back to top
View user's profile Send private message
Bellisio



Joined: 29 Oct 2008
Posts: 19
Location: State of CT - DDS

PostPosted: Thu Jun 12, 2014 4:23 pm    Post subject: Reply with quote

good news, Evan will this version be available for all soon?
Back to top
View user's profile Send private message
cguanes



Joined: 08 Feb 2012
Posts: 8

PostPosted: Thu Jun 12, 2014 6:59 pm    Post subject: Slowness 3.6.6.178 Reply with quote

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
Back to top
View user's profile Send private message
bslatner



Joined: 12 Jun 2014
Posts: 2

PostPosted: Thu Jun 12, 2014 11:18 pm    Post subject: Having the exact same problem Reply with quote

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?
Back to top
View user's profile Send private message
shawnC



Joined: 22 Nov 2011
Posts: 13

PostPosted: Fri Jun 13, 2014 8:15 am    Post subject: Reply with quote

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?
_________________
http://stackexchange.com/users/13638/gbn
Back to top
View user's profile Send private message
daveh0ward



Joined: 13 Jun 2014
Posts: 2

PostPosted: Fri Jun 13, 2014 2:52 pm    Post subject: Reply with quote

Having the same problem described.
On version 3.7.7.246 and it is painfully, unusably slow. Please advise asap.
Back to top
View user's profile Send private message AIM Address
GrahamH



Joined: 05 Jul 2010
Posts: 6

PostPosted: Mon Jun 16, 2014 3:09 pm    Post subject: Frequent Update release Reply with quote

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
Back to top
View user's profile Send private message
cguanes



Joined: 08 Feb 2012
Posts: 8

PostPosted: Mon Jun 16, 2014 3:15 pm    Post subject: it is working back Reply with quote

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

Thank you.
_________________
Carlos Guanes
Back to top
View user's profile Send private message
GrahamH



Joined: 05 Jul 2010
Posts: 6

PostPosted: Mon Jun 16, 2014 3:18 pm    Post subject: Reply with quote

Glad to hear it's working Carlos Smile
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Go to page 1, 2  Next
Page 1 of 2

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group