Home Forums SQL Server 2005 Administering How to find the stored procedure causing performnace problem RE: How to find the stored procedure causing performnace problem

  • June 7, 2011 at 5:45 am

    #1334915

    Just bear in mind that the query stats DMV is dependant on the plan remaining in cache. If the plan is recompiled or aged out, the stats are lost. If a plan is never cached, it won't appear in the query stats DMV at all.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass