SQL Server Availability Monitoring

Total article views: 425 | Views in the last 30 days: 39

 Rate this |   Join the discussion |  Briefcase

This VB script will attempt to make a connection to all SQL Servers enumerated in the SQLInventory table over Named Pipes and TCP\IP. If a SQL Instance is listed, it will attempt TCP\IP connections using both port and instance name. Once the connection is established to each server using each protocol, the script will query sysprocesses to verify the connection is over the right protocol, to ensure that no redirection using aliases is taking place. Any connection failures will be dumped into an email, with the failure message. Once all connections have been attempted, the email will be sent, assuming a failure occurred.

If the NPDisabled or TCPDisabled bits are set in the SQLInventory table, that protocol will not be monitored for that server.

Total article views: 425 | Views in the last 30 days: 39