Metrics install automatically if you have SQL Monitor installed.
If you are using Redgate’s SQL Server monitoring tool, SQL Monitor, you can instantly install and run this metric on your servers.
This metric gives you an indication of how much time is spent waiting to send information over a network. High values may indicate slow network performance, but may also indicate that clients are not fetching data quickly, or are leaving connections open with data still available to be fetched.
An alert is not defined, because the “normal” value for this metric can vary greatly from system to system. You could add an alert once the baseline for your environment has been established.OS Wait Time: Async_Network_IO,
OS Wait Time: Async_Network_IO (secs)
Asynchronous network IO references the amount of time that SQL Server processes spend waiting on data to be transmitted to and from the client. High values may indicate slow network performance, but may also indicate that clients are not fetching data quickly, or are leaving connections open with data still available to be fetched. Values are displayed in seconds, and are collected once per server (this is a server-centric value).
The T-SQL query that will collect data
Instances to collect from
Databases to collect from
Use collected or calculated values
Check the Use a calculated rate of change between collections check box
An alert is not defined