1 Reply Latest reply on Apr 7, 2017 1:54 PM by mandevil

    trend for wait type

    wingszeto

      In Solarwind DPA, it  provides wait type information for the server it is monitoring.  If we encounter a high wait type in 10 mins during the day (an incident) and we want to see the history trend  for that wait type per day, week or even month, is it doable in DPA?

       

      Wing

        • Re: trend for wait type
          mandevil

          Set your timeframe to be within an hour or within a day. If on a day, set the interval to be 1 day.

          Then click on the waits tab in the dimensions listed across the top. Click on the 1 vertical bar. Click into the wait you want to see patterned.

          Now click back to timeslice.

           

          What you will see are the top SQL statements that are experiencing that particular wait. It's not perfect, but it is a decent proxy... (the aggregate of the top SQL - so the height of the entire bar represents the amount of that particular wait state, but subcategorized by the impacted SQL)

          See if that gets you close to what you are looking for.