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,
David
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.
Robert, the async_network_io waits from that machine are from an application running through a database link to our main production EMR database. We will be replacing it with a much better design.
Thank you for your expertise.
