How can I measure network performance between the Notification Server and a remote SQL server?
The SQL ping tool (current version is 1.4) has been created to measure the response time for a SQL query from the NS to a remote SQL server. High network latency is a known cause of poor NS performance. The tool can also be used from other computers with .NET 1.1 installed, such as Deployment Servers or Recovery Servers.
The tool will first create a temporary table with 64kb of data on the target SQL server. It will then retrieve the contents of the temporary table on a fixed interval. By measuring the round trip time, an evaluation of the network communications between the NS host and the SQL server can be accomplished. This pure read operation test is designed to incur zero CPU load on the SQL server (which can be proven with a SQL Profiler trace).
In a pristine environment, response times would be between 0 and 15 milliseconds (ms). There would be zero network failures. A congested network can cause delays in forwarding packets between the servers, including re-sending of the same request.
The boxes at the top keep a running count of response times.
Note: For each error, the first 100 characters of the error message are included in the last column.