June 25, 2019 at 5:54 pm
Hi All,
We have SQL Server instance running on a VM. Now we wanted to move the instance to sql azure managed instance.
Just want to find out different to measure Latency between App and DB VM’s. This will help us to determine the latency to sql azure db's post migration.
Also, please let me know if there is any native of doing this without any 3rd party tool intervention. just want to know if there anything from windows side or application side which has the capability of logging the latency?
Thank you,
Sam
June 25, 2019 at 6:47 pm
You can certainly add logging to your app that captures start of query and then when the datareader/datatable fills. I don't know of anything directly that does this natively in Windows.
There is a PSPing tool, and this might help you do some testing: https://blogs.msdn.microsoft.com/igorpag/2013/12/15/azure-network-latency-sql-server-optimization/
June 26, 2019 at 3:57 am
Thank you Steve.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply