SQL Instances are unable to establish external relationship with VM

Products

• VCF Operations/Automation (formerly VMware Aria Suite)
• VMware Aria Operations 8.x

Issue/Introduction

• Relationship details will not be established on a few of the instance.

• The properties will not get populated for discovered relationships.

Environment

Aria Operations 8.18.x

Cause

The adapter associates VMs with SQL Server instances using four heuristics:

1. Matching the MAC address to the VM object in Aria Ops.

2. Querying vCenter directly to match the MAC address.

3. Matching the hostname with the adapter instance host field.

4. Matching the hostname using the 'general | current_owner' property.

Since VMs can have multiple NICs, they may have multiple MAC addresses. The MP attempts to locate any VM with a matching MAC address. However, because the Aria Ops API does not support querying across all MAC addresses, the MP iterates through all VMs, resulting in a process that does not scale efficiently.

Resolution

The issue has been addressed in Microsoft SQL Server Management Pack version 9.0.0.0100

As an interim solution, configure the SQL Adapter instance using vCenter credentials.

By design, establishing the relationship per SQL instance requires at least 50 minutes.

Note: If the workaround is ineffective or there are challenges in obtaining vCenter credentials, the recommended solution is to upgrade the SQL MP to v9.0.0.0100

Additional Information

Reference Link: Management Pack for Microsoft SQL Server