Microsoft SQL Server cluster Discovery

Discovery identifies Microsoft SQL Server instances that are part of a cluster in the CMDB by the cluster name rather than as individual configuration items (CI).

An SQL Server instance that is part of a cluster is listed as a related item in the CI record for the server that hosts the instance with a Runs::Runs on relationship.

Viewing discovered relationships

By default, a CI record for a server (node) hosting an SQL Server instance that is part of a cluster does not display the instance or the cluster as related items.

To see the cluster information on a CI record:
  1. Add the Cluster Nodes related list to the form. This list displays the name of the node and the parent cluster.
    Figure 1. Windows server and cluster
  2. Click the cluster name in the related list to drill into the CI record for that cluster. Individual SQL Server instances running on that cluster are listed in the Related Items hierarchy. The names in the list contain the instance name prepended to the host name with the @ symbol. In this example, MSSQLCLUSTER is the SQL Server instance name, and cluster-node2 is the name of the Windows host.
    Figure 2. Cluster and related SQL instance name
  3. Click the name of the SQL Server instance in the Related Items list to open the record for that CI. The instance name is expressed in the format instance@host name and displays the relationship hierarchy to the configured number of levels, including the system databases that the instance uses, the cluster on which the instance runs, and the server on which the cluster runs.
    Figure 3. SQL instance CI record

Defining a clusterable process

  1. Open the desired process classifier (Discovery Definition > CI Classification > Process).
  2. Add the Parameters related list (if not visible).
  3. Click New in the Parameters related list and add a new parameter, using the following values:
    • Name: Unique name of your choosing.
    • Type: Enter Cluster.
    • Value: Enter the following statement.
    resourceType: "Resource Type",
    isMatch: function(process, resource) {
        //javascript function that returns true if a resource matches the classified process
    }
    Table 1. Defining Clusterable Processes
    Parameter Description
    resourceType Resource type the platform should look for in the cluster's Windows Cluster Resources related list.
    isMatch Determines if the cluster resource that is found, based on the type, is a match for the classified process being examined.
    Figure 4. SQL Cluster Parameter