Finding out if mirroring is active and alive
Posted on 2010-11-14
I have an SQL Server 2008 running with a mirrored database, with distinct machines (master, slave, witness). I need to program an administrator's tool where he can see with a kind of traffic light if mirroring is active and working, and if the sql server instances are healthy and running.
How can this be achieved ? Is there any kind of API or .NET library for examining these tings ? Or could I talk to the network ports (5022 for the mirroring, for example) to find this out, and if yes, what must be called ?