The Network panel tracks the performance of the network connection being used by your monitored SQL Server. Unexpected spikes in packet rates and response times may warn you about the beginning of a serious performance issue. Chronically high network metrics may indicate excessive network traffic or a high server workload, which may require you to move some monitored instances to other computers to free up network resources and balance the workload.
SQL Server Throughput chart
The SQL Server Throughput chart plots how many packets this SQL Server sends and receives over time.
Metric | Why it is important |
---|---|
A consistently high rate may indicate that the packet size is too small. | |
A consistently high rate may indicate that the packet size is too small. |
VM Network Usage Throughput chart
The VM Network Usage Throughput chart plots how much data this virtual machine transmits and receives in KB/second over time. For additional information about how SQL Diagnostic Manager works with virtual machines, see How SQL Diagnostic Manager works with a virtual environment.
Metric | Why it is important |
---|---|
Transmitted KB/sec | A consistently high rate may indicate that data throughput is saturated. Investigate load balancing your network traffic. |
Received KB/sec | A consistently high rate may indicate that data throughput is saturated. Investigate load balancing your network traffic. |
Host Network Usage Throughput chart
The Host Network Usage Throughput chart plots how much data this host server transmits and receives in KB/second over time. For additional information about how SQL Diagnostic Manager works with virtual machines, see How SQL Diagnostic Manager works with a virtual environment.
Metric | Why it is important |
---|---|
Transmitted KB/sec | A consistently high rate may indicate that data throughput is saturated. Investigate load balancing your network traffic. |
Received KB/sec | A consistently high rate may indicate that data throughput is saturated. Investigate load balancing your network traffic. |
Response Time gauge
The Response Time gauge displays the time (in milliseconds) SQL diagnostic manager currently needs to send a simple SQL command to the SQL Server instance, have it processed, and receive the returned result set. This value corresponds to the SQL Server Response Time metric.