Measuring latency for stretched SharePoint farm topologies

This blog post focuses on measuring latency for SharePoint stretched farm topologies.

As per this article https://technet.microsoft.com/en-us/library/cc748824.aspx there is a requirement for <1ms latency between web front end servers and database servers.

I've been assisting customers in measuring their latency in order to see if they are able to meet this requirement.
The solution that I provided for them is a PowerShell script that can be left running for a number of hours (e.g. 120 hours (5 days)).

The script outputs directly into a SQL database.  This provides greater flexibility when analysing the data; for example below I have connected PowerBI to the database to illustrate latency/ roundtrip values:

In the example above, you can see that <1ms latency has only been achieved approximately 45% of the time.

You can download the script here: https://github.com/moss-sjeffery/sp-powershell-scripts/blob/master/Measure-NetworkLatency.ps1

Please be aware that you will need to build a database to output the information to. In my lab environment I created a database called 'Net_Latency', with a table called 'Latency' containing the following columns:

Cheers! Hope this helps.

@moss_sjeffery