ManageEngine® SQLDBManager Plus


Cluster Details

<< Prev

Home

Next >>

 

SQL Server - Cluster Details

 

SQLDBManager Plus lets you monitor the status of your SQL Server Clusters and Cluster resources. Click on the monitor name to see all the Cluster details listed under the following links:

 

Cluster Details

Parameters

Description

Cluster Name/IP Address

The name/IP Address of the cluster.

Quorum Owner Node

The node in which the sql cluster configuration data is currently accessible.

Quorum Path

The path to the quorum files.

Quorum Type

The current quorum type. The following are the possible values:

  • Majority
  • No Majority

Number of Nodes

The total number of nodes in a cluster.

Max Nodes

The maximum number of nodes that can participate in a cluster.

Number of Networks

The number of networks used by the server cluster for communication.

Resources Online

The SQL server cluster resources that are currently online.

Resources Offline

The SQL server cluster resources that are currently offline.

Resource Groups Online

The SQL server cluster resource groups that are currently online.

Resource Groups Offline

The SQL server cluster resource groups that are currently offline.

Disks in Use

The number of disks currently in use in the cluster.

 

Disk Utilization

You can monitor the total Disk Utilization of a Cluster.

Parameters

Description

Used Percentage

The total percentage of used disk space in a Cluster.

Free Percentage

The total percentage of free disk space in a Cluster.

Size

The total size of disk memory, in megabytes.

Used

The total used space in the disk, in megabytes.

Free

The total free space available in the disk, in megabytes.

Storage

Parameters

Description

Path

The path (including the drive letter if present) of the clustered disk partition.

Volume Label

Specifies access to the VolumeLabel property, which is the volume label of the partition.

Size

The total size for the partition, in megabytes.

Used

The total used space in the partition, in megabytes.

Free

The total free space available for the partition, in megabytes.

Used Percentage

The percentage of used space in the partition.

Free Percentage

The percentage of free space in the partition.


Nodes

Parameters

Description

Node Name

Specifies the label by which the node is known.

State

Specifies the current state of a node. Node states can be:

  • Up - The node is physically plugged in, turned on, booted, and capable of executing programs.
  • Down - The node is turned off or not operational.
  • Joining - The node is in the process of joining a cluster.
  • Paused - The node is running but not participating in cluster operations.
  • Unknown - The operation was not successful.


Networks

Parameters

Description

Name

Specifies the name of the network.

Role

Provides access to the network's Role property i.e, the role of the network in the cluster. The following are the possible values:

  • 0 - None - The network is not used by the cluster.
  • 1 - Cluster - The network is used to carry internal cluster communication.
  • 2 - Client - Not supported - Windows Server 2003: The network is used to connect client systems to the cluster.
  • 3 - Both - The network is used to connect client systems and to carry internal cluster communication.

State

Specifies the current state of the network. The following are the possible values:

  • -1 - Unknown - The operation was not successful.
  • 0 - Unavailable - All of the network interfaces on the network are unavailable, which means the nodes that own the network interfaces are down.
  • 1 - Down - The network is not operational; none of the nodes on the network can communicate.
  • 2 - Partitioned - The network is operational, but two or more nodes on the network cannot communicate. Typically a path-specific problem has occurred.
  • 3 - Up - The network is operational; all of the nodes in the cluster can communicate.

Address

Specifies the address for the entire network or subnet.


Resource Groups

Parameters

Description

Name

The name of the Resource group.

Current Node

The node in which the sql server is currently running.

Preferred Node

The node that is primarily responsible for hosting a cluster resource.

State

The current state of the resource group. The following are the possible values.

  • Unknown (-1)
  • Online (0)
  • Offline (1)
  • Failed (2)
  • PartialOnline (3)
  • Pending (4)

<< Prev

Home

Next >>

SQL Configuration Options

SQL Server Audit Reports with Real Time Alerts