Lesson Learned #153: PHP Console Script for Testing connection in Azure SQL

This post has been republished via RSS; it originally appeared at: Azure Database Support Blog articles.

To connect to Azure SQL Database we could use multiple tools or coding languages like C#, PHP, Java, etc.. In some situations, we need to test our application, for example, how much time take a single connection, review my retry-logic, review the connection, etc.. 

 

In this URL you could find an example about several operations that you could use using PHP. 

 

This application has been designed with a main idea: how to obtain information about the elapsed time in the connectivity process and the query execution to a database of Azure SQL Database using PHP ( ODBC or Microsoft Drivers for PHP for SQL Server). This PHP console script runs in Windows and Linux.

 

This PHP console script has the main features:

  • Connect using different driver measuring the time spent.
  • Once you have established the connection runs multiple times the query SELECT 1 measuring the time spent.
  • Once you have established the connection runs multiple times any query that you need with a random parameter measuring the time spent.
  • Check if the port is open.
  • Report all the ports that the client has opened.
  • All the operations will be saved on a file called Output.log.

You could find the instrucctions in readme file.

 

As always, all feedback and contributions are very welcome.

 

Enjoy!

 

REMEMBER: these articles are REPUBLISHED. Your best bet to get a reply is to follow the link at the top of the post to the ORIGINAL post! BUT you're more than welcome to start discussions here:

This site uses Akismet to reduce spam. Learn how your comment data is processed.