2 Replies Latest reply on Dec 7, 2017 7:12 PM by dkranes

    What exactly does this screen tell me


      How exactly are top machine defined?  We are looking into decommissioning the top one and want to understand what impact that might have.



      Thank you,


        • Re: What exactly does this screen tell me

          Within any of the dimensions (tabs) at the top of the trends or timeslice views, we always rank them by highest wait time attributed.

          Meaning the top machines in your list are associated with queries experiencing the highest wait time. You can click on any of the machines in the list and see exactly what queries are coming from them. Or filter like that by any dimension.

          So for machines (database client host), you are seeing the top client machine that you want to sunset.

          Since most of the waits are async_network_io, that usually points to very slow application consumption of the data (not a database server issue per se). Think MS Access.Or anything built in '95.