Applications Systems

DPA Table Tuning Advisor page cannot display data

The Table Tuning Advisor page in DPA displays a message that DPA was unable to retrieve information about a table. The database instance that includes this table is part of a SQL Server Availability Group (AG). The database instance was acting as the primary replica for the AG, but a failover occurred.

First published date

11/9/2018 10:32 PM

Last published date

11/9/2018 10:32 PM

Overview

The Table Tuning Advisor page in DPA displays a message that DPA was unable to retrieve information about a table.

Product section

Database Performance Analyzer

Cause

Probable causes for this message are:

The database instance is acting as the secondary replica for the SQL Server Availability Group (AG) containing the table's database, and therefore table information is not available.

If you are monitoring the database instance that is currently acting as the primary replica, you can view table tuning advice for the table on that instance. However, the advice might be different due to environmental differences.
Another query error is preventing DPA from retrieving the information. Review the DPA log files for the specific error.

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.