Red Gate forums :: View topic - 3.1.0.5208 (and greater) Logging and Database Connections..
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

3.1.0.5208 (and greater) Logging and Database Connections..

Search in SQL Source Control 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
sillv0r



Joined: 07 Feb 2013
Posts: 2

PostPosted: Thu Feb 07, 2013 3:13 pm    Post subject: 3.1.0.5208 (and greater) Logging and Database Connections.. Reply with quote

I'm using the dedicated model and it appears that 3.1.0.5208 (and greater) takes on the order of hours to complete an initial link. The database is large, but version 3.1.0.4829 would complete the initial link within the hour if not before 30 minutes.

[Logging]
One thing I've been able to notice different is 3.1.0.5208 logs the entire contents of every database object full details of stored procedures, views, tables, etc. and is only able to complete a single object in just over a second. While, 3.1.0.4829 merely logs the name of the database objects and can chew through several objects within the same second.

[Database Connections]
One other behavior difference I've noticed is that 3.1.0.4829 appears to hold onto a database connection and reuse it. While 3.1.0.5208 and greater (so far) appears to chew through database connections. Looking at Resource Monitor I see SSMS.exe chewing through source ports while the initial link is going on.

Any ideas? I'm staying on 3.1.0.4829 for now.

Regards.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6581

PostPosted: Mon Feb 11, 2013 4:18 pm    Post subject: Reply with quote

You have already got a support call open with Red Gate via email, reference number F0069027.

Personally I can't say what the problem is. I don't know what you mean by "chewing connections", though. SQL Source Control I believe is like other Red Gate SQL Tools in that it uses the default settings of the .NET ADO client and therefore will pull connections out of a pool and re-use them, thus saving it the expense of always having to make a fresh connection for every operation. My opinion is you're probably barking up the wrong tree, reverse-engineering wise.
Back to top
View user's profile Send private message
HoofHearted



Joined: 14 Feb 2013
Posts: 1

PostPosted: Thu Feb 14, 2013 3:17 pm    Post subject: Reply with quote

Brian,
I believe you owe sillv0r an apology. I just downloaded the update made available today and looked in the release notes and found the following:
"Drastically reduced the number of connections made to the SQL Server instance hosting a linked database. This also reduces the number of queries against those databases"

Not only did you dismiss a customer's valid complaint ("barking up the wrong tree", indeed!!), but Red Gate has listed this as a feature instead of a bug fix.

What a slap in the face!! Nice customer service.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6581

PostPosted: Thu Feb 14, 2013 4:30 pm    Post subject: Reply with quote

I did not answer this post comprehensively because this customer already had a support call open with us via email and he has been notified.

Sorry you're dissatisfied.
Back to top
View user's profile Send private message
Chris George



Joined: 31 May 2009
Posts: 21
Location: Red Gate Software Ltd

PostPosted: Fri Feb 15, 2013 11:15 am    Post subject: Re: Reply with quote

HoofHearted wrote:
Brian,
I believe you owe sillv0r an apology. I just downloaded the update made available today and looked in the release notes and found the following:
"Drastically reduced the number of connections made to the SQL Server instance hosting a linked database. This also reduces the number of queries against those databases"

Not only did you dismiss a customer's valid complaint ("barking up the wrong tree", indeed!!), but Red Gate has listed this as a feature instead of a bug fix.

What a slap in the face!! Nice customer service.


Hi there,

I work on the SQL Source Control project, and I would like to apologise for any misunderstanding surrounding the release notes for the recent update.

Listing the connections issue under Features was an error on our part, and is something I have now corrected.

We hope that you find the new release to be a bit faster than the previous few, and look forward to hearing more feedback from you.

Regards
Chris
_________________
Chris George
SQL Source Control
Red Gate Software
Back to top
View user's profile Send private message
sillv0r



Joined: 07 Feb 2013
Posts: 2

PostPosted: Fri Feb 15, 2013 10:20 pm    Post subject: Follow up Reply with quote

Just a follow up.

SQL Source Control release 3.1.4.72 resolved my issues.


Quote:
You have already got a support call open with Red Gate via email, reference number F0069027.


The only reason I posted in the forums was I had not heard any updates on said support ticket in over a week.


Quote:
My opinion is you're probably barking up the wrong tree, reverse-engineering wise.



I do not believe that watching Resource Monitor is considered reverse engineering.

Thanks.
Back to top
View user's profile Send private message
Chris George



Joined: 31 May 2009
Posts: 21
Location: Red Gate Software Ltd

PostPosted: Sat Feb 16, 2013 12:52 am    Post subject: Reply with quote

Hi sillv0r

It's great to hear that the latest release has solved your issue! Very Happy

Kind Regards

Chris
_________________
Chris George
SQL Source Control
Red Gate Software
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
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