Unless the application is cluster-aware, when using Microsoft SQL Enterprise Manager to administer the service, you should register it by the switchable resource name (the name by which users access the server using TCP/IP). This gives you a continuous monitor of the viability of this path.

If you register the SQL Server by the system name, you can also monitor the system.

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment