To discover the resources of AlwaysOn availability group, you must run the following Knowledge Scripts:
Discovery_SQLServerAlwaysOnCluster: Discovers the availability group listeners on an AlwaysOn cluster.
Discovery_SQLServer: Discovers the availability group resources under the listener nodes.
AppManager for SQL Server 8.1 or later release includes a new discovery script, Discovery_SQLServerAlwaysOnCluster that you can use to discover the availability group listeners on a cluster. An availability group listener is a virtual network name (VNN) to which clients can connect to the AlwaysOn availability group. This script only discovers the listener nodes.
NOTE:The Discovery_SQLServerAlwaysOnCluster Knowledge Script does not discover and monitor cluster shared disks through listener node.
You can discover AlwaysOn Availability Groups only on AppManager version 8.0.x or later.
In AppManager 8.0.2, NetIQ recommends that you use the Control Center Console to view the objects under the availability group.
By default, this script runs once for each computer.
To correctly discover and monitor a Microsoft AlwaysOn cluster, this Knowledge Script requires local Administrator access to each node of the Microsoft cluster. To do this, run the netiq service as a domain user account and a member of the local Administrator group on each member of the cluster. Without this access, the discovery fails because it relies on the Microsoft Cluster API to properly access cluster resources.
The Cluster Administrator can be used to administer a cluster, provided the account you are using has the required permissions and group memberships. The local Administrator account and local system account always have access to the cluster. You can use another account to administer a cluster with Cluster Administrator if the following requirements are true:
The account has permission to administer the cluster. You must use Cluster Administrator to assign permissions, not Windows Group Administrator.
The account is a domain account, which is a member of the local Administrators group.
The account is a member of the local Administrators group on each node of the cluster.
The account can be a member of other groups, such as global groups, as long as it is a domain account.
By default, this Knowledge Script raises an event when discovery fails.
NOTE:AlwaysOn availability group does not support delta discovery. If you add or remove a cluster node (availability group replica), you must first delete the listener node objects and run both Discovery_SQLServerAlwaysOnCluster and Discovery_SQLServer Knowledge Scripts again to discover the listener nodes and the resources.
NT Machine Folder
Set the Values tab parameters as needed:
|
Description |
How to Set It |
|---|---|
|
Job Failure Notification |
|
|
Raise event if job fails unexpectedly |
Select Yes to raise an event if the discovery job fails unexpectedly. The default is Yes. |
|
Event severity when job fails unexpectedly |
Set the event severity level, from 1 to 40, to indicate the importance of an event that is raised when the job fails unexpectedly. The default is 5. |
|
Additional Settings |
|
|
Event Details |
|
|
Event detail format |
Select the format in which you want to display the event detail. You can select from HTML Table or Plain Text. The default is HTML Table. |
|
Raise event if discovery succeeds? |
Select Yes to raise an event if discovery succeeds. The default is unselected. |
|
Event severity when discovery succeeds |
Set the event severity level, from 1 to 40, to reflect the importance of an event in which discovery succeeds. The default is 25. |
|
Raise event if discovery is not applicable? |
Select Yes to raise an event if discovery is not applicable. For example, if you run this Knowledge Script other than an cluster instance, discovery is not applicable. The default is Yes. |
|
Event severity when discovery is not applicable |
Set the event severity level, from 1 to 40, to reflect the importance of an event in which discovery is not applicable. The default is 15. |
Run the Discovery_SQLServer Knowledge Script on the discovered listener nodes to discover the availability group resources under the listener nodes.
NOTE:
To run this Knowledge Script on availability group listeners, you need public, read-only, view server state, and view any definition SQL Server permission.
You must configure the users in security manager before running this script. For more information about configuring users in security manager, see Section 2.7, Configuring SQL Server User in Security Manager.
For more information on Discovery_SQLServer script, see Section 2.5, Discovering SQL Server Resources