Home Forums SQL Server 2008 SQL Server 2008 - General Puzzle with Sproc intermittently runs slow but runs faster other days. RE: Puzzle with Sproc intermittently runs slow but runs faster other days.

  • November 21, 2014 at 1:44 am

    #1760028

    Looks like bad parameter sniffing and/or stale statistics.

    Here's a good article on the subject: http://www.mssqltips.com/sqlservertip/3257/different-approaches-to-correct-sql-server-parameter-sniffing/

    -- Gianluca Sartori