SQL Cluster Process Test

This test reports the current state and resource usage of the cluster process, and promptly alerts administrators if the cluster goes down or is up and consuming more resources than it should.

Note:

This test will report metrics only if the eG agent is installed on a remote Windows host. The eG agent should be installed using the credentials of a domain user possessing valid permission to log into the target Microsoft SQL server.

Target of the test : A Microsoft SQL Cluster

Agent deploying the test : A remote agent

Outputs of the test : One set of results for the cluster being monitored

Configurable parameters for the test
  1. TEST PERIOD – How often should the test be executed
  2. Host – The IP address of the SQL cluster
  3. Port – The port on which the cluster is listening.
  4. Detailed Diagnosis - To make diagnosis more efficient and accurate, the eG Enterprise suite embeds an optional detailed diagnostic capability. With this capability, the eG agents can be configured to run detailed, more elaborate tests as and when specific problems are detected. To enable the detailed diagnosis capability of this test for a particular server, choose the On option. To disable the capability, click on the Off option.

    The option to selectively enable/disable the detailed diagnosis capability will be available only if the following conditions are fulfilled:

    • The eG manager license should allow the detailed diagnosis capability
    • Both the normal and abnormal frequencies configured for the detailed diagnosis measures should not be 0.
Measurements made by the test
Measurement Description Measurement Unit Interpretation

Service availability

Indicates the availability of the cluster service.

Percent

The availability is 100% when the cluster process is running.

This measure will report the value 0, if the cluster process is not running.

Processes running

Indicates the number of instances of the cluster process that are currently running.

Number

The value 0 for this measure is indicative of the non-availability of the cluster service.

The detailed diagnosis of this measure reveals the process ID of each running instance of the cluster process and the resource and I/O usage of each instance, so that you can quickly identify which instance is resource-intensive.

CPU utilization

Indicates the percentage of CPU resources used by the cluster process.

Percent

A value close to 100% indicates that the cluster process is hogging the CPU resources of the ‘active’ node in the cluster.

Handle count

Indicates the number of handles opened by the process.

Number

An increasing trend in this measure is indicative of a memory leak in the process.

Number of threads

Indicates the number of threads that are used by the process.

Number

 

Virtual memory used

Indicates the amount of virtual memory that is being used by the process.

MB

 

Private memory used

Indicates the amount of memory that this process has been allotted, that cannot be shared with other processes.

MB

 

Pool paged

Indicates the amount of memory currently in the pool paged area of system memory.

MB

 

Pool non paged

Indicates the amount of memory currently in the pool non-paged area of system memory.

MB

 

I/O data rate

Indicates the rate at which processes are reading and writing bytes in I/O operations.

Kbytes/Sec

This value counts all I/O activity generated by each process and includes file, network and device I/Os.

I/O data operations

Indicates the rate at which the process is issuing read and write data to file, network and device I/O operations.

Operations/Sec

 

I/O read data rate

Indicates the rate at which the process is reading data from file, network and device I/O operations.

Kbytes/Sec

 

I/O write data rate

Indicates the rate at which the process is writing data to file, network and device I/O operations.

Kbytes/Sec

 

Page fault rate

Indicates the total rate at which page faults are occurring for the
threads of all matching processes.

Faults/Sec

A page fault occurs when a thread refers to a virtual memory page that is not in its working set in main memory. This may not cause the page to be fetched from disk if it is on the standby list and hence already in main memory, or if it is in use by another process with
whom the page is shared.

Memory working set

Indicates the current size of the working set of a process.

MB

The Working Set is the set of memory pages touched recently by the threads in the process. If free memory in the computer is above a threshold, pages are left in the Working Set of a process even if they are not in use. 
When free memory falls below a threshold, pages are trimmed from Working Sets. If they are needed they will then be soft-faulted back into the Working Set before leaving main memory.

The detailed diagnosis for this test provides details of the individual process instances and their individual working sets.

Comparing the working set across process instances indicates which instances taking up excessive memory.