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?

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

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: Which configuration should the solutions architect use to meet the company’s needs while minimizing changes and infrastructure overhead?

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

1 Comment

Author

I guess:
Truncate the events_statements_summary_by_digest table.

Emily

5 hours ago

Permalink

Reply

Free study guides, practices test, sample questions

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?

1 Comment

Leave a Reply to Emily Cancel reply