Crushing SQL Server Performance After Upgrade

TheSQLGuruTheSQLGuru Posts: 78 Silver 2
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.

Comments

  • 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.
  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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!
  • 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.
Sign In or Register to comment.