What's the fastest method to check SQL server availability?

c# sql-server smo
iLemming picture iLemming · Jul 15, 2010 · Viewed 8.9k times · Source

What's the best method to check if SQL server exists or not?

I'm trying Microsoft.SqlServer.Management.Smo.Server.PingSqlServerVersion() and it works fine if server exists and available. But it kinda pretty slow, if there is no such a server.

Is there any fast enough method to check without even defining user credentials (only the server name), if a server exists?

What do you recommend to use?

Answer

Ben Robinson picture Ben Robinson · Jul 15, 2010

You could still use Microsoft.SqlServer.Management.Smo.Server.PingSqlServerVersion() but use it asynchronously. e.g. you could call it via a BackWorker class. The DoWork event would call Microsoft.SqlServer.Management.Smo.Server.PingSqlServerVersion(). The RunWorkerCompleted would just set a boolean variable to true. THat way you could fire it off, wait however long you wanted, check the boolean value and if it was not true then you would know that the SQL server had not responded yet and you could cancel the BackgroundWorker.

Related questions

How to restore a database from C#

I have a SQL 2008 DB. I am running a form that backs that DB up, then tries to update it. If the update fails the idea is to restore that backup. Here is the code I am using to restore …

Read More
How to list available instances of SQL Servers using SMO in C#?

Can anybody explain me what I wrong I am doing in the following piece of code: DataTable dt=SmoApplication.EnumAvailableSqlServer(true); Server sr = new Server("Test"); foreach(DataBase db in sr.DataBases) { Console.WriteLine(db["name"]); } It gives an exception …

Read More
smo restore database

I use SQL Server SMO to restore a .bak to a new database, but failed to work. sql server is 2012 and smo object version is from the latest sdk version 11.0 file .bak was created using sql management studio 2012, same local …

Read More