Home Forums SQL Server 2008 SQL Server 2008 Administration SQL Query Performance RE: SQL Query Performance

  • July 31, 2012 at 10:25 am

    #1519837

    Grant Fritchey (7/31/2012)

    The DMV stores data for queries that are currently in cache. As soon as a plan ages out of cache all the information in that DMV is lost. So it really depends on how volatile the plan cache on your machine is for how much information is available to you through that DMV. For a complete measure of query performance, I'd go with extended events.

    Thank You

    So I would use that DMV as part of troubleshooting for a "SQL is slow NOW" situation

    Where would I start for a "SQL has been slow erratically"

    Thanks