Crushing SQL Server Performance After Upgrade

TheSQLGuru

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...

TheSQLGuru

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>

Brian Donahue

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!

TheSQLGuru

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!