Home Forums SQL Server 2008 T-SQL (SS2K8) Sp runs from 7 sec to 10 min (UnitPricingTrans) RE: Sp runs from 7 sec to 10 min (UnitPricingTrans)

  • November 4, 2013 at 9:07 am

    #1663863

    SSChampion,

    I re-compiled procedure using local variables.

    But... first run with ( @P_UNIT_TYPE = 'VEH' )

    took 11 seconds.

    Next run ( @P_UNIT_TYPE = 'COM' )

    is taking more than 2 min... and still running.

    Still parameter sniffing occurring?...