Post reply

performance history

  • June 10, 2015 at 5:33 pm

    #398572

    how can we track any database performance issues for last week?? (in a particular date/time). Any DMVs?

  • June 10, 2015 at 5:46 pm

    #1804547

    snuthalapati (6/10/2015)

    how can we track any database performance issues for last week?? (in a particular date/time). Any DMVs?

    You might be able to find something left over in the DMVs but you might have a better chance with DBCC TIMEWARP. 😛 Most people have systems that run nightly runs that frequently drive everything out of the DMVs related to performance so it's not real likely to find something from last week unless you're saving such data on a regular basis.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • June 11, 2015 at 1:37 am

    #1804593

    In short, no.

    The DMVs don't store data, they're views into the current internal state of SQL Server. Any restart will clear the DMVs and most performance-related data (dm_exec_query_stats and related DMVs) are based on the plans in memory and a whole pile of things can remove plans from cache or even clear the entire cache.

    This is why performance benchmarks are such good things to set up and keep.

    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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply