Version 3.6.6.178 is REALLY slow

• 
  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 June 04, 2014 09:54

  - 0 +
• 
  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:
  

  <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 June 06, 2014 14:21

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

  <?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 June 09, 2014 17:41

  - 0 +
• 
  Hello,
  
  I've contacted you through our support system. Can you send your log file there?
  
  Thanks,
  Evan

  Evan Moss June 09, 2014 17:48

  - 0 +
• 
  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 June 11, 2014 13:00

  - 0 +
• 
  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 June 12, 2014 11:09

  - 0 +
• 
  good news, Evan will this version be available for all soon?

  Bellisio June 12, 2014 11:23

  - 0 +
• 
  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]

  cguanes June 12, 2014 13:59

  - 0 +
• 
  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 June 12, 2014 18:18

  - 0 +
• 
  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 June 13, 2014 03:15

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

  daveh0ward June 13, 2014 09:52

  - 0 +
• 
  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 June 16, 2014 10:09

  - 0 +
• 
  I just installed the version 3.6.8.222 from your link above and it is working back on speed.
  
  Thank you.

  cguanes June 16, 2014 10:15

  - 0 +
• 
  Glad to hear it's working Carlos

  GrahamH June 16, 2014 10:18

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

  acrawford June 16, 2014 10:32

  - 0 +
• 
  It's working for me as well, thank you!

  daveh0ward June 16, 2014 11:41

  - 0 +
• 
  Working for me as well. Back to normal.

  bslatner June 16, 2014 15:06

  - 0 +
• 
  works here too. Thank you.

  Bellisio June 16, 2014 15:16

  - 0 +
• 
  Speed is even better than before - thanks for all of your help!
  
  Doug

  Ozzie June 19, 2014 10:14

  - 0 +

Add comment

Please sign in to leave a comment.