-
タイトル
List of actions that are performed when Availability Group is added within the ApexSQL Audit GUI -
説明
What is the list of actions and steps that are performed when an Availability Group is added through the ApexSQL Audit's GUI.?
-
対策
Immediately after the name of the Listener is entered/typed within the ApexSQL Audit GUI:
1. The application checks if server side components can be contacted via port 60408
2. Central server sends a request to remote server's server side components via 60408 to return the info about the server
- server side components, that is, SYSTEM user queries the WMI from the primary replica to check if it's an Availability Group
- if it is - it connects to the primary replica (SYSTEM) and executes the query which returns the info about the cluster (the query we sent you)
3. The info is returned to the central process via 60408 port and if it is recognized as an AG, the info about replicas is displayed in the auditing agent properties (special auditing agent properties dialog for AG)
4. After clicking on OK, the Central process sends a signal over 60408 to install the ApexSQL Audit Distributed process (our collecting agent is installed) and the credentials are checked, to connect to the instance, to create the folders, and then returns via the 60408 port that the operation is successful.
5. The Distributed process contacts the Central process via 64561 port.
6. After all the checks are completed, the AG is successfully added in the server tree