Query analysis provides AI-powered insight into why queries may be performing poorly, and where applicable offers suggestions of ways to improve performance. Advice is available for SQL Server and PostgreSQL database instances.

How to use

First, ensure you have configured Monitor AI for 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 generate guidance.

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.

As well as helping identify improvement opportunities, the AI system aims to identify when queries are already running well, and to avoid inventing unnecessary changes. Consequently there won't necessarily always be improvement suggestions.