Using the wait statistics, I managed to prove that ASYNC_NETWORK_IO is the key bottleneck with our SQL server. We have around 80% waiting. I would like to add additional monitoring on our SQL servers to have an idea of when and what causes these waitings for reports.
In perfmon, I currently have:
Network adapter Received bytes / sec.
Network adapter Sent bytes / sec.
Network adapter Bytes Total / sec.
Network adapter Sent packets / sec.
Network adapter Packet received / sec.
In addition to these counters, I expected to add something that would allow me to monitor the acceptance of client-side data.
Is there a perfmon counter that allows me to do it?