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

Audit Monitoring