Lesson Learned #147: Checking the connectivity to Azure SQL DB and MI

Published 11-24-2020 12:04 PM 1,156 Views

Sometimes we're used to recieve service request that our customers needs to know the time spent in order to connect to their Azure SQL Database or Managed Instance or simply to check intermittent connections that they could have in their environment.

 

For these types of situation I would like to suggest to review two PowerShell Script that you could find on this URL that allow to obtain this information. 

 

Enjoy!

%3CLINGO-SUB%20id%3D%22lingo-sub-1928293%22%20slang%3D%22en-US%22%3ELesson%20Learned%20%23147%3A%20Checking%20the%20connectivity%20to%20Azure%20SQL%20DB%20and%20MI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1928293%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3ESometimes%20we're%20used%20to%20recieve%20service%20request%20that%20our%20customers%20needs%20to%20know%20the%20time%20spent%20in%20order%20to%20connect%20to%20their%20Azure%20SQL%20Database%20or%20Managed%20Instance%20or%20simply%20to%20check%20intermittent%20connections%20that%20they%20could%20have%20in%20their%20environment.%20%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20these%20types%20of%20situation%20I%20would%20like%20to%20suggest%20to%20review%20two%20PowerShell%20Script%20that%20you%20could%20find%20on%20this%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FJMNetwalker%2FAzureSQLConnectivityChecker%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EURL%3C%2FA%3E%20that%20allow%20to%20obtain%20this%20information.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EEnjoy!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1928293%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3ESometimes%20we're%20used%20to%20recieve%20service%20request%20that%20our%20customers%20needs%20to%20know%20the%20time%20spent%20in%20order%20to%20connect%20to%20their%20Azure%20SQL%20Database%20or%20Managed%20Instance%20or%20simply%20to%20check%20intermittent%20connections%20that%20they%20could%20have%20in%20their%20environment.%20%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-TEASER%3E
Version history
Last update:
‎Nov 24 2020 12:06 PM
Updated by: