Monitoring SQL/Server Clusters

[MikeLacey]

We are having some issues with clustering.

We are doing active/active sql clustering and active/passive sql clustering

We have 2 xml scripts which, I believe, allow active/passive clustering (I believe the script stops the SQL agent on the passive node)

However in an active/active environment, where the sql instance could be on either node I don't belive this will work as both agents need to be up and the DB instance could be on either node, HP OV keeps trying to contact the database where the connection was configured.

Any ideas welcome

Mike
======================================
scripts below




Apminfo.xml


<?xml version=&quot;1.0&quot; ?>

<APMClusterConfiguration xmlns=&quot;

http://www.hp.com/OV/opcapm/cluster&quot;>

<Application>

<Name>dbspi_mssqlserver</Name>

<Instance>

<Name>SQlServer</Name>

<Package>sdcntstgclu01.ukroi.tesco.org</Package>

</Instance>

</Application>

</APMClusterConfiguration>


dbspi_mssqlserver.apm.xml


<?xml version=&quot;1.0&quot;?>

<APMApplicationConfiguration xmlns=&quot;

http://www.hp.com/OV/opcapm/app&quot;>

<Application>

<Name>dbspi_mssqlserver</Name>

<Template>DBSPI-MSS-05min-Reporter</Template>

<Template>DBSPI-MSS-1d-Reporter</Template>

<Template>DBSPI-MSS-05min</Template>

<Template>DBSPI-MSS-15min</Template>

<Template>DBSPI-MSS-1h</Template>

<Template>DBSPI-MSS6-05min</Template>

<Template>DBSPI-MSS6-15min</Template>

<Template>DBSPI-MSS6-1h</Template>

<Template>DBSPI Microsoft SQL Server</Template>

<Template>Tesco SQL Server - SPI</Template>

<StartCommand>dbspicol ON $instanceName</StartCommand>

<StopCommand>dbspicol OFF $instanceName</StopCommand>

</Application>

</APMApplicationConfiguration Mike
________________________________________________________________

&quot;Experience is the comb that Nature gives us, after we are bald.&quot;

Is that a haiku?
I never could get the hang
of writing those things.

 

[MikeLacey]

Looks as if only active/passive monitoring is supported.... ah well.

Of course, if anyone knows any different - please post the details. Mike
________________________________________________________________

&quot;Experience is the comb that Nature gives us, after we are bald.&quot;

Is that a haiku?
I never could get the hang
of writing those things.