A database specialist is checking Performance Insights and observes an alert message that starts with the following phrase: `Performance Insights is unable to collect SQL Digest statistics on new queries`¦`Which action will resolve this alert message?

On: January 8, 2025

A company is using an Amazon Aurora MySQL database with Performance Insights enabled.

A database specialist is checking Performance Insights and observes an alert message that starts with the following phrase: `Performance Insights is unable to collect SQL Digest statistics on new queries`¦`Which action will resolve this alert message?

Truncate the events_statements_summary_by_digest table.

Change the AWS Key Management Service (AWS KMS) key that is used to enable Performance Insights.

Set the value for the performance_schema parameter in the parameter group to 1.

Disable and reenable Performance Insights to be effective in the next maintenance window.

Previous Post: How does the AWS Enterprise Support Concierge team help users?

Next Post: Which configuration should the solutions architect use to meet the company’s needs while minimizing changes and infrastructure overhead?

Learn & move to cloud

A database specialist is checking Performance Insights and observes an alert message that starts with the following phrase: `Performance Insights is unable to collect SQL Digest statistics on new queries`¦`Which action will resolve this alert message?

Leave a Reply Cancel reply