Checking availability of server

Question

Checking availability of server

stormsentinelcammy

SSCrazy

Points: 2493
More actions
May 13, 2011 at 7:57 am

#389521

Hi guys, is there a way to check if a server is accessible? I have an issue with a particular server where it goes offline and back online randomly based on traffic and networking issues, is there a way either through C#, vb 2008 or any other method that will allow me to check to see if the server is online and accessible?

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

colin.Leversuch-Roberts SSC Guru Points: 52643 More actions · Answer 1

I use a ping from a reporting server, it alerts me if a ping fails.

You can query the service using a linked server but linked server queires can sometime be difficult if the target isn't there!

SQL Diagnostic Manager will notify you if the service is unavailable.

It depends upon the exact issue you're getting - ping is about the safest and easiest,

[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/

Syed Jahanzaib Bin hassan SSChampion Points: 11410 More actions · Answer 2

schedule a job with email on another SQL Server

exec xp_cmdshell 'ping serverip\servername'

if you not get the ping then email to you otherwise not,I might be schedule on OS level also I think so

My Blog
www.aureus-salah.com

stormsentinelcammy SSCrazy Points: 2493 More actions · Answer 3

You think its possible for me to add that into SSIS or just create a whole new step in an agent job? I'll look up the diagnostic manager now because this network issue should not be happening, its just that the network here is awful. A lot of downtime sometimes.

Syed Jahanzaib Bin hassan SSChampion Points: 11410 More actions · Answer 4

can create SSIS as well and whole code can be in a single agent job

My Blog
www.aureus-salah.com

stormsentinelcammy SSCrazy Points: 2493 More actions · Answer 5

Ok Syed, I was just about to ask about that because I remember seeing something like that a while ago. I'll look into it now, do I need to have the server IP and servername or is it possible to just ping the server?

Syed Jahanzaib Bin hassan SSChampion Points: 11410 More actions · Answer 6

you need any 1 of them SERVER IP or is there DNS in your organization then SERVER NAME can use also

IP is best

My Blog
www.aureus-salah.com

stormsentinelcammy SSCrazy Points: 2493 More actions · Answer 7

Thanks syed, I have the IP of the server, I will just set up another step in the job where if the step succeeds then continue with the job and if not just kick out a fail email. I would do it in the package but if I were to do it in the package and the access is not available the package will run and fail because of the connection not available, instead of having the package run, I think its better to do what you said which is to just add a step and ping the server. I'll try it out and let you know the results in a few mins.

colin.Leversuch-Roberts SSC Guru Points: 52643 More actions · Answer 8

if you want to either mail me direct or send me a message I'll send you the code I use to ping servers - you can't just issue xp_cmdshell 'ping xxx'

I have a job which runs every 5 mins, but it could run every minute, which checks connectivity across all my servers, some of which connect by vpn - hence my interest. This runs from within the data centre as against Diagnostic Manager which runs locally - data centre is not at offices so i need to know if we lose connectivity.

[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/

stormsentinelcammy SSCrazy Points: 2493 More actions · Answer 9

Thanks for your help Syed, what you suggested as far as the ping worked, I also had an issue running the xp_cmdshell command on the server because it wasn't activated, below I have pasted the code that I used that worked in activating it and allowing me to run the command. Hope that helps anyone that might need that kind of information.

EXEC sp_configure 'show advanced options', 1

GO

RECONFIGURE WITH OVERRIDE

EXEC sp_configure'xp_cmdshell', 1

go

RECONFIGURE WITH OVERRIDE

stormsentinelcammy SSCrazy Points: 2493 More actions · Answer 10

hey colin, that would be great if you could send me that code. I would be most appreciative. Would you rather email it to me or post it in the forum as an attachment?