Database Management

DPA monitoring fails when a SQL Server AG is registered through the listener

You might see errors such as the following in the logs: "DatabaseMonitorJobListener:62 - Stopping monitor in SummaryPollJob".

First published date

1/10/2023 7:36 PM

Last published date

2/20/2025 10:20 PM

Overview

When you register a SQL Server Availability Group (AG) through the listener for monitoring in DPA, duplicate files collected through polling are not handled correctly in some situations, which can cause monitoring to fail. Errors such as the following can appear in the logs:

DEBUG (2021-04-03T17:16:50,214+0300) [repositoryManager-thread-23] {name=DBSERVER02 via AGLISTENER01} DatabaseMonitorJobListener:62 - Stopping monitor in SummaryPollJob

Product section

Database Performance Analyzer

Resolution

If possible, register each instance separately instead of registering the listener. If that is not possible, then disable IO stats polling by setting the advanced option IO_STATS_POLL_ENABLED to False.

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.