Monitoring SQL Server Cluster

  • We are busy developing an application the monitors your SQL server in terms of performance, data redundancy, etc.

    The problem we have is in cluster to exactly know when the cluster fails over or fail fail back. It will not help us to monitor the Windows Event Log, because that events are only written after the event occured.

    Could somebody help me on this? Specifically to monitor the cluster for these events so that I can build the monitoring into the application.

    Regards

    Raino Botha

  • How about writing your own simple service which can be registered with the cluster administrator?

    Your application could then log the information about when the service is starting or stopping, as well as possibly the actual host name that the service is running on.

    Regards,

    ifx

  • Allready tried that.

    Is there a method to polll the cluster service itself for this type of events? Preferably to the virtual machine.

     

    Regards

  • Yep, its possible to write an application which runs on the cluster and writes cluster events to a port.

    Check out the following page on MSDN:

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/mscs/mscs/notification_port_example.asp

Viewing 4 posts - 1 through 3 (of 3 total)

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