有没有办法在连接之前ping MSSQL数据库

Question

The connection to the database is very fragile, so I try to test the connection before make a link to it. I found pg_connect and mysql_ping and how-do-i-ping-the-mysql-db-and-reconnect-using-pdo, but none has anything to do with MSSQL or function that I can use.

Is there a way I can test the database before I connect to it?

Answer 1

You might set the timeout to a very small number and call something like

SELECT 1;

or

SELECT GETDATE();

and see, if there is some result coming back...

If the connection is broken, such tiny requests should break as well.

In case fragile does not mean broken, you might measure a standard call and compare the execution speed...