Bad performance and regular timeouts using shared model

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

Bad performance and regular timeouts using shared model

Postby knoeppler » Thu Nov 22, 2012 4:14 pm

Hi,

we are using the shared database development model with SVN. Ever since the last SQL Source Control Update (to Version 3.1.0.4829), we receive regularly error messages about failing to poll for 3 seconds. We have sent error messages about this to Redgate several times via the error reporting feature, though without a reaction so far. Also, when trying to commit, the commit dialog sometimes shows a message saying "Waiting for other operations to complete" indefinitely, keeping users from committing their changes.

Accidentally, I discovered the Asteriods easter egg while waiting for the commit dialog, but actually I'd prefer if I could commit my changes...

If nothing else helps, could you consider rolling back to handling the shared model like you did before version 3, or at least give the user a choice in this respect? We never had a problem finding out who changed what when committing changes, but now we regularly have problems committing changes, to an extent that renders SQL Source Control almost unusable.
knoeppler
 
Posts: 2
Joined: Wed Sep 07, 2011 8:51 am

Postby andy.campbell.smith » Mon Nov 26, 2012 5:15 pm

We're aware of some issues people have been seeing with the shared model in SQL Source Control 3.1 - if you want, you can always downgrade to SQL Source Control 3.0 and wait for the patched update.

The installer for SQL Source Control 3.0 is here: ftp://support.red-gate.com/patches/SQLS ... 3.4214.exe

If you uninstall SQL Source Control 3.0 and install that, you ought to be able to continue to work with your database with the old-style limited change-tracking. Let me know if that helps at all! I'll update this thread as soon as there's a newer version of SQL Source Control out.
Andy Campbell Smith

Red Gate Technical Support Engineer
andy.campbell.smith
 
Posts: 173
Joined: Thu Oct 20, 2011 11:19 am
Location: Red Gate Software

Postby harbourscape » Tue Nov 27, 2012 11:21 pm

Hi,

Our team is having exactly the same issues as knoeppler. Team of 8 all on V3.1.0.4829 of SSC doing Shared development with TFS. The software is unusable as we are not able to refresh the commit changes tab without getting either a timeout or polled 3 times error. I have also sent both the error reports and a support ticket to RedGate but have had no response so far.

I just tried downgrading as suggested above and when I tried to re-link the databases to TFS with V3.0 I got the error "Operation is not valid due to the current state of the object." Are there any other ways that we could fix this in the interim? Unluckily for us, we only started using SSC this week!

Thanks in advance,

John.
harbourscape
 
Posts: 2
Joined: Tue Nov 27, 2012 11:05 pm

Postby andy.campbell.smith » Wed Nov 28, 2012 3:52 pm

Hmm. You could try reducing the polling time of SQL Source Control. You can do this by editing the RedGate_SQLSourceControl_Engine_EngineOptions.xml file in C:\\Users\\<username>\\Appdata\\Local\\Red Gate\\SQL Source Control 3.

Set the trace interval time as follows:

<DefaultTraceMinimumInterQueryTimeInMillis>60000</DefaultTraceMinimumInterQueryTimeInMillis>

(you may need to add that line if it's not already there).

Once done, ensure you restart SSMS; also, you will need to perform this change on each PC / for each user.
Andy Campbell Smith

Red Gate Technical Support Engineer
andy.campbell.smith
 
Posts: 173
Joined: Thu Oct 20, 2011 11:19 am
Location: Red Gate Software

Postby harbourscape » Sun Dec 02, 2012 11:48 pm

Hi Andy,

Thanks for your response, it seems to have fixed the issue for us.

Do you have any idea when a patch is likely to be released?
When it is released, should we remove the configuration, or leave it as it is?

Cheers,

John.
harbourscape
 
Posts: 2
Joined: Tue Nov 27, 2012 11:05 pm

Postby andy.campbell.smith » Mon Dec 03, 2012 2:47 pm

We're working on a patched version of SQL Source Control currently, but I don't know when that'll be ready - it shouldn't be too long, but I can't promise any dates. I'll post here as soon as it's out.

All you changed in the config file is the max timeout value - you can safely leave that as it is if the software's patched.
Andy Campbell Smith

Red Gate Technical Support Engineer
andy.campbell.smith
 
Posts: 173
Joined: Thu Oct 20, 2011 11:19 am
Location: Red Gate Software

Postby sgilboy » Wed Jan 02, 2013 5:57 pm

Any word on this Patch?

I cannot get my Source Control 3 install to pull up stuff in the "Commit" tab since last update.. currently on 3.1.0.4829

I get either

"Failed to poll database after 3 attempts"

or

"Timeout Expired"

when i just try to get the list of objects needing to be checked in

We are using Vault as our source control depository and it works great with Visual Studio for code, the Vault client works great too, so I know that it is in full working order
sgilboy
 
Posts: 30
Joined: Wed Jun 22, 2011 7:38 pm

Postby sgilboy » Thu Jan 03, 2013 7:37 pm

So:
- Uninstalled the version of 3.1
- Downloaded the version 3.0 linked to above...
- Install went smooth, all my savings were saved
- Can now pull up that commit tab and check items in
sgilboy
 
Posts: 30
Joined: Wed Jun 22, 2011 7:38 pm

Yep

Postby bdw429s » Tue Jan 08, 2013 5:48 pm

My team of 9 has been experiencing the same issue for a while now. I finally got around to googling today and I'm glad I found this thread. I'm commenting mostly to subscribe so I will be sure to know when the update is out. I hope the update is soon-- the usability of SSC has been greatly impacted by this repeated error.
bdw429s
 
Posts: 20
Joined: Thu Aug 09, 2012 4:05 pm
Location: Kansas

Postby andy.campbell.smith » Thu Jan 24, 2013 2:22 pm

Just to let you know - we've now released a new version of SQL Source Control which should hopefully fix some of the problems you were seeing. You can download using the Check for Updates functionality within the tool - let me know if that sorts anything out for you!
Andy Campbell Smith

Red Gate Technical Support Engineer
andy.campbell.smith
 
Posts: 173
Joined: Thu Oct 20, 2011 11:19 am
Location: Red Gate Software

Postby sgilboy » Wed Jan 30, 2013 1:47 pm

Has anyone out there in this thread tried the new update to address this problem?

I rolled back to an old version and don't want to be the guinea pig for this new version :-)
sgilboy
 
Posts: 30
Joined: Wed Jun 22, 2011 7:38 pm

Postby bdw429s » Wed Jan 30, 2013 7:03 pm

My team has updated. We had some weird locking errors when only half the team was on the new version and the other half was on the old version. A restart of SQL seemed to fix it, so it may have just been a gremlin.

Since then, I haven't noticed the timeout errors at all. I E-mailed my team to see if anyone else has seen the timeouts since upgrading. From what I can tell, it's stable.

Thanks RedGate!
bdw429s
 
Posts: 20
Joined: Thu Aug 09, 2012 4:05 pm
Location: Kansas

Postby bdw429s » Wed Jan 30, 2013 7:05 pm

Wow, I just noticed that a brand new minor release (3.1.2) just came out today. All the site says is "several major bug fixes". Does anyone know specifically what it fixes?

~Brad
bdw429s
 
Posts: 20
Joined: Thu Aug 09, 2012 4:05 pm
Location: Kansas

Postby andy.campbell.smith » Thu Jan 31, 2013 4:26 pm

The two major bugs addressed in that minor release were SOC-4584 (Crash when removing polling manager) and SOC-2779 (Crash when object is defined in multiple files on disk). We also fixed an issue that was causing trouble in SQL Compare comparing to versions in source control history.

A little update - the improvements to polling problems are just that, improvements (i.e. not a true fix). The root cause of the problem is that all users in a shared model environment are polling the same table to get blue blobs - that's still the case, but we've about halved the execution time of the polling query, so it should be significantly less of an issue.

We are working on a new model of polling for shared model environments that won't rely on every user polling the same table, but that's still in the pipeline. Hopefully this ought to help a lot in the meantime!
Andy Campbell Smith

Red Gate Technical Support Engineer
andy.campbell.smith
 
Posts: 173
Joined: Thu Oct 20, 2011 11:19 am
Location: Red Gate Software


Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 2 guests