PsPing your Azure SQL Server

PsPing tool is part of the sysinternals PsTools download found –  ( https://docs.microsoft.com/en-us/sysinternals/downloads/psping)

This is the tool of choice when wanting to find out latency to your Azure SQL Server. In addition to standard ICMP ping functionality, it can report the latency of connecting to TCP ports, the latency of TCP round-trip communication.

I use this to find the latency from my location to various Azure SQL Servers which are in different Azure regions. I am based in the heart of England so let’s look and compare a couple of locations (just out of curiosity). Once you have downloaded the tool you will need to CD to the directory and call the following command.

PsPing <servername><port>

This is my ping stat to a server based in West Europe.

pingstat1

Now let’s check and compare to a server based in West Central USA.

pingstat2

Quite a latency difference, well that’s expected.

One thought on “PsPing your Azure SQL Server

  1. Pingback: Tracking Latency To Azure With PsPing – Curated SQL

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s