This command is intended to help measure SQL Server network latency by establishing a connection and making a simple query. This is a better alternative than ping because it actually creates the connection to the SQL Server, and times not only the entire routine, but also how long the actual queries take vs how long it takes to get the results.
To time the execution of “SELECT TOP 100 * FROM sys.objects” 3 times on sqlserver2014a, using Windows Authentication to log into the server.
Test-SqlNetworkLatency -SqlServer sqlserver2014a
To time the execution results return of “select top 10 * from otherdb.dbo.table” 10 times on sqlserver2014a, sqlcluster, and sqlserver
Test-SqlNetworkLatency -SqlServer sqlserver2014a, sqlcluster, sqlserver -Query “select top 10 * from otherdb.dbo.table” -Count 10