2 Replies Latest reply on Dec 12, 2016 1:11 PM by deescott

    DPA over time gives a false picture

    deescott

      Hello,

      We are migrating many applications from our mainframe into sql server.  We are constantly dealing with requests for more cpu and memory. When I query DPA, even over as small a period as 24 hours, all the peaks of cpu and memory have been averaged out and show no issues.  For example, During a one hour period, cpu can peak at 75% and memory at 70% and when you look at the 24 hour shot of this, both peaks are gone, and the line shows hovering at 25%.   Is there a fix for this?  This averaging out makes it very hard to analyze the needs accurately.  It's even worse for the longer time periods.

       

      Thanks for any help or suggestions,

      Dianne