You could create an ssis package and try and connect, if it does not respond the step fails and you then have an on fail step to insert into a table. I use a foreach loop container and check all the prod servers this way, if one does not respond an email alert is sent.

Andrew