Redgate Assistant provides AI-powered insights into why queries may be performing poorly, and where applicable, offers suggestions of ways to improve performance. Advice is available for SQL Server, PostgreSQL, Oracle, MySQL and MongoDB instances.

To learn more about the data used for query analysis and how it is handled, visit the Redgate AI Trust Hub.

Prerequisites

Before using query analysis, ensure you have configured Redgate Assistant.

How to use

On the Server overview page, scroll to the Top queries section, and select a query of interest to show more information about it. In the expanded Query Details view, immediately below the query text is a purple Analyze Query button, which will open Redgate Assistant.

AI-powered advice is based on a combination of the query text itself, and the execution plan where available. It aims to walk you through the most likely root cause of a problem, as well as to provide concrete suggestions on resolution steps.