1 / 12

How to ... create a working apminfo.xml file to monitor a clustered MS SQL Server

How to ... create a working apminfo.xml file to monitor a clustered MS SQL Server. Markus Buehl Manfred Eibl SGBU Germany Net Age Solutions GmbH Version 1.0 15. Oktober 2003. Prerequisites. Monitoring of clustered applications through XML Files is currently supported with

elizabethn
Download Presentation

How to ... create a working apminfo.xml file to monitor a clustered MS SQL Server

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. How to ...create a working apminfo.xml file to monitor a clustered MS SQL Server Markus Buehl Manfred Eibl SGBU Germany Net AgeSolutions GmbH Version 1.0 15. Oktober 2003

  2. Prerequisites Monitoring of clustered applications through XML Files is currently supported with • OVO Windows (7.0 or higher) • OVO Unix (7.14 or higher) • Windows 2000: MS Cluster Service on Advanced Server and Data Center • Application-side clustering, like the fail-over mechanism of OV Service Desk can not be covered with this technique !!! • This setup does not depend on the application running on this cluster HP presentation template user tutorial

  3. What needs to be done? There are two files, which have to be created or edited: • apminfo.xmlThis file defines which Clustered Applications should be monitored „cluster aware“The apminfo file can hold information for various applications running on that cluster. Each application then requires it‘s own section in the apminfo as well as it‘s corresponding .apm.xml file. • <Application>.apm.xmlThis file defines which policies should switch monitoring in the cluster together with the application.Some examples already come with SPIs, for example:dbspi_mssqlserver.apm.xmldbspi_oracle.apm.xml…msexchange.apm.xml HP presentation template user tutorial

  4. File Locations • apminfo.xmlHas to be created/placed manually per node directly on the node into the conf/OpC/directory of the agent • <Application>.apm.xmlWhen placed into /var/opt/OV/share/databases/OpC/mgd_node/customer/ms/intel/nt/monitor(OVO Unix) or \Program Files\HP OpenView\Instrumentation\Windows <version>\<version>\SPI for Databases(OVO Windows) the xml will be deployed automatically with the “SPI for Databases” instrumentation to the nodes. HP presentation template user tutorial

  5. apminfo.xmlThe description from the OVOW 7.20 Online Help <?xml version="1.0" ?> <APMClusterConfiguration> <Application> <Name> Name of the cluster-aware application </Name> <Instance> <Name> Instance name used by the application. This name is used for start and stop commands and should usually correspond to the name used to designate this instance in messages. </Name> <Package> Instance name of the Resource Group used by the cluster software </Package> </Instance> </Application> </APMClusterConfiguration> HP presentation template user tutorial

  6. What does this mean ???„cluster aware application“ • Name of the cluster-aware application This is basically the name of the <Application>.apm.xml file, which should be used for this clustered Application In our case we used dbspi_mssqlserver.apm.xml although we modified the list of templates, therefore in our case the value is dbspi_mssqlserver HP presentation template user tutorial

  7. What does this mean ???„Instance name“ • The virtual name of the clustered applicationplus (especially for Databases) the Instance which should be monitored. • The „virtual name“ was usually defined when the Cluster has been setup and shows up on two places in the MS Cluster Administration Tool: This value is defined through the Properties of the „SQL Network Name“: HP presentation template user tutorial

  8. What does this mean ???„ Resource Group “ • The Name of the „Resource Group“ is the name of the Group where the Packets to switch with this application are defined HP presentation template user tutorial

  9. This led us to: <?xml version="1.0" ?> <APMClusterConfiguration> <Application> <Name>dbspi_mssqlserver</Name> <Instance> <Name>VSQLSTAT\c2stat</Name> <Package>SQL Group</Package> </Instance> </Application> </APMClusterConfiguration> The name of the corresponding .apm.xml File The Name of the SQL Server Instance to be monitored (optional, only needed when monitoring different instances ) HP presentation template user tutorial

  10. Known Errors and Limitations • PathSince it appears, that the path of „dbspicol“ can not always be found correctly, it is recommended to place the full path into the <Application>.apm.xml: • \usr\OV\bin\OpC\cmds\dbspicolfor an agent comming from OVO Unix • <installation_directory>\Installed Packages\{790C06B4-844E-11D2-972B-080009EF8C2A}\bin\OpC\cmds\dbspicol for an agent comming from Windows You may also apply the path mentioned above to the Windows Path variable. OVOW provides a tool for this task called „Set Path“ (calling the dbspisetpath.vbs script). • Application Failover not using MS ClusterHere it needs to be recommended to set up an own set of monitoring and scripts: • find an event that shows the cluster switch (on all clustered nodes, either active or passive • trigger an automatic command to change monitoring with opctemplate (-e or –d) HP presentation template user tutorial

  11. One more example... HP presentation template user tutorial

More Related