Bad performance and incorrectly included items on Get Latest

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 incorrectly included items on Get Latest

Postby sognibene » Thu Jun 13, 2013 3:54 pm

Hello,

I have SQL Source Control 3.4.2.61 running against TFS 2010 and SQL Server 2012 SP1 with the latest CU installed. My SQL Server is local on my workstation (quad core, 14GB RAM) and TFS is on the network.

I am trying to get the latest "Filter" from source control. When I select only the filter and click "Get latest", the SQL Source Control "Retrieving changes from source control" hangs and uses 100% cpu for several minutes.

I then get a "Warnings" dialog that includes among other things a High warning that a deployment script with no name ("") will be used, and then it says it will drop a user and three schemas.

Why would this happen when I am just trying to get the updated filter?

Thanks.



Severity: High
Title: Some of the changes you selected are covered by the migration script ""
This will be used to generate the deployment script.
----------------------------------------------------
Severity: Low
Object: ReportViewer
Title: Dropping a user is a potentially dangerous operation. Dependencies for the ReportViewer user are not selected automatically. If you are sure you want to drop this user please select the objects that belong to this user manually.
----------------------------------------------------
Severity: Low
Object: [I removed the name here]
Title: Dropping a schema is a potentially dangerous operation. Dependencies for the [I removed the name here] schema are not selected automatically. If you are sure you want to drop this schema please select the objects that belong to this schema manually.
----------------------------------------------------
Severity: Low
Object: [I removed the name here]
Title: Dropping a schema is a potentially dangerous operation. Dependencies for the [I removed the name here] schema are not selected automatically. If you are sure you want to drop this schema please select the objects that belong to this schema manually.
----------------------------------------------------
Severity: Low
Object: SQLCop
Title: Dropping a schema is a potentially dangerous operation. Dependencies for the SQLCop schema are not selected automatically. If you are sure you want to drop this schema please select the objects that belong to this schema manually.
----------------------------------------------------
Severity: Low
Object: [I removed the name here]
Title: Dropping a schema is a potentially dangerous operation. Dependencies for the [I removed the name here] schema are not selected automatically. If you are sure you want to drop this schema please select the objects that belong to this schema manually.
----------------------------------------------------
Severity: Low
Object: tSQLt
Title: Dropping a schema is a potentially dangerous operation. Dependencies for the tSQLt schema are not selected automatically. If you are sure you want to drop this schema please select the objects that belong to this schema manually.
----------------------------------------------------
sognibene
 
Posts: 7
Joined: Tue May 28, 2013 7:01 pm

Postby David Atkinson » Thu Jun 13, 2013 11:08 pm

SQL Source Control is apparently trying to pull in a "migration script" as part of the "get latest" operation. Can you visit the Migrations tab and see if there's anything there that shouldn't be? If you find something, try deleting it and trying again. However, it's a little strange that it's apparently not got a valid file name. You could try looking at the migrations folder in source control and seeing if there's anything suspect in there.

Failing this, unlink your database and relink it without setting the migrations folder and try the get latest again.

Migration scripts are used when you want to customize the behavior of SQL Compare's comparison and sychronization engine.

David Atkinson
Red Gate
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Postby sognibene » Fri Jun 14, 2013 2:38 pm

I checked the Migrations tab and there are two scripts listed. Both of them are valid. I looked through all the code in both the SQL files and there were no commands that affected any users.

I hadn't patched SQL compare in a while so I am going to restore a new copy of my database and try again. If I can reproduce the problem is there a log file I can send in that might be helpful?
sognibene
 
Posts: 7
Joined: Tue May 28, 2013 7:01 pm

Postby Evan Moss » Mon Jun 17, 2013 9:51 pm

Hi sognibene,

We've opened up a ticket for you and will be in contact shortly. In the meantime, you can find the log files for SQL Source control here: YOURDRIVE:\\Users\\YOURUSERPROFILE\\AppData\\Local\\Red Gate\\Logs\\SQL Source Control 3

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


Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 2 guests

cron