• Waits over a period of a year aren't all that useful, too low a granularity. When doing wait type analysis, you usually look at the difference between the waits a minute or two apart, that gives information on the current problems, which allows investigation into current problems.

    Waits aggregated over months or years are just numbers with minimal meaning.

    Oh, and there are waits that you should just ignore no matter how high the number is, often because said waiting processes are normal and expected and often background tasks.

    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