Red Gate forums :: View topic - Crushing SQL Server Performance After Upgrade
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

Crushing SQL Server Performance After Upgrade

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



Joined: 12 Mar 2007
Posts: 19

PostPosted: Thu Nov 15, 2012 10:42 pm    Post subject: Crushing SQL Server Performance After Upgrade Reply with quote

I just upgraded to SSC 3.1.0.4829 and I am getting frequent calls to this type of execution:

declare @p1 datetime
set @p1='2012-11-15 21:30:26.057'
exec tempdb.dbo.RG_WhatsChanged @SinceWhen=@p1 output,@DatabaseList=N'<stringarray><element><seqno>1</seqno><item>eFR5010Dev</item></element></stringarray>',@Quietly=0,@MatchCountLimit=3
select @p1

It is running for 10-11 seconds, burning 420K reads and eating 20-40% of my CPU. Prior version did NOT do this!!!

I am using SQL 2008R2 and SSMS build is 10.50.2796.

Code storage is Vault 5.1.2


***************************
separate issue: I traced THOUSANDS of calls like this when I went to view history:

exec dbo.spgettxhistory @objid=4309,@rowlimit=1,@begindate='2011-10-02 14:28:28.397',@enddate='2011-10-02 14:28:28.397',@startversion=0
go
exec sp_reset_connection
go
exec dbo.spgettxhistory @objid=4309,@rowlimit=1,@begindate='2011-10-02 14:28:28.397',@enddate='2011-10-02 14:28:28.397',@startversion=0
go
exec sp_reset_connection
go
exec dbo.spgettxhistory @objid=4309,@rowlimit=1,@begindate='2011-10-02 14:28:28.397',@enddate='2011-10-02 14:28:28.397',@startversion=0
go
exec sp_reset_connection
go
exec dbo.spgettxhistory @objid=4309,@rowlimit=1,@begindate='2011-10-02 14:28:28.397',@enddate='2011-10-02 14:28:28.397',@startversion=0
go
exec sp_reset_connection
go
exec dbo.spgettxhistory @objid=4309,@rowlimit=1,@begindate='2011-10-02 14:28:28.397',@enddate='2011-10-02 14:28:28.397',@startversion=0
go
exec sp_reset_connection
go
exec dbo.spgettxhistory @objid=4309,@rowlimit=1,@begindate='2011-10-02 14:28:28.397',@enddate='2011-10-02 14:28:28.397',@startversion=0
go

that sure looks like an infinite looping bug...
_________________
Kevin G. Boles
SQL Server MVP 2007-2012
Indicium Resources, Inc.
Back to top
View user's profile Send private message AIM Address Yahoo Messenger
TheSQLGuru



Joined: 12 Mar 2007
Posts: 19

PostPosted: Thu Nov 15, 2012 10:45 pm    Post subject: EngineOptions Reply with quote

Here is my engine options settings file in the source control 3 folder:

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<!---->
<EngineOptions version="2" type="EngineOptions">
<PollingEnabled>False</PollingEnabled>
<DefaultTraceMinimumInterQueryTimeInMillis>0</DefaultTraceMinimumInterQueryTimeInMillis>
<SysObjectsMinimumInterQueryTimeInMillis>0</SysObjectsMinimumInterQueryTimeInMillis>
<SysTypesMinimumInterQueryTimeInMillis>0</SysTypesMinimumInterQueryTimeInMillis>
<DefaultTraceMinimumRequestedInterQueryTimeInMillis>0</DefaultTraceMinimumRequestedInterQueryTimeInMillis>
</EngineOptions>
_________________
Kevin G. Boles
SQL Server MVP 2007-2012
Indicium Resources, Inc.
Back to top
View user's profile Send private message AIM Address Yahoo Messenger
Brian Donahue



Joined: 23 Aug 2004
Posts: 6645

PostPosted: Wed Nov 21, 2012 10:36 am    Post subject: Reply with quote

I'm sorry you have encountered this issue. I will be responding to you via email with the information relevant to troubleshooting this problem.

Thanks!
Back to top
View user's profile Send private message
TheSQLGuru



Joined: 12 Mar 2007
Posts: 19

PostPosted: Wed Nov 21, 2012 6:12 pm    Post subject: SG Vault Reply with quote

I isolated the spgettxhistory calls to Source Gear Vault.

STILL cannot believe you kill my box with the get version calls though. There simply MUST be a way to disable that!
_________________
Kevin G. Boles
SQL Server MVP 2007-2012
Indicium Resources, Inc.
Back to top
View user's profile Send private message AIM Address Yahoo Messenger
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