Buffer metrics are not collecting for Microsoft SQL Server Adapter in Aria Operations

Products

• VCF Operations/Automation (formerly VMware Aria Suite)

Issue/Introduction

• While the Microsoft SQL Server Adapter instance shows OK (collecting) in Aria Operations, buffer metrics are not being collected
• In the /storage/vcops/log/MicrosoftSQLServerAdapter_####.log on the node where the adapter instance resides, you see entries similar to the below:

[105229] 2026-01-20T20:08:06,709+0000 ERROR [Collector worker thread 19] (13420363) com.bluemedora.exuno.DataProvider.error - com.bluemedora.microsoft.sqlserver.ThreadUtils.JdbcPoller: pollCompletionService method returned null or timed out before the result was returned with timeout set to {30} seconds

Environment

Aria Operations 8.18.x

Cause

This issue is observed when the SQL instance is particularly large, and polling it for metrics takes longer than the default 30s timeout.

Resolution

To resolve this issue, increase the timeout for the Microsoft SQL Server adapter instance:

1. Navigate to Administration > Integrations
2. Select the Microsoft SQL Server adapter instance in question, click the ellipsis and then Edit
3. Expand Advanced Settings
4. Change the Thread Timeout (seconds) setting from 30 to 60 
5. Click Save

Note: In the event that the metrics still do not start collecting, and the log still shows the timeout error but with the new value - continue to double the value until the metrics begin collecting.