Redgate Monitor 14

Availability: Public preview. Self-hosted Redgate Monitor 14.28 or later only - Redgate Assistant is not available on earlier versions or on Redgate Monitor SaaS.

Redgate Assistant (RGA) is an AI assistant built into Redgate Monitor. RGA is disabled by default, see Prerequisites to enabling RGA to enable it.

Ask a question in plain language about the health and performance of your estate, and RGA answers from Monitor's own data to help you find what's going on. It is currently available through the Global Dashboard (Overview tab).

To learn more about Redgate AI, visit our AI hub.

Prerequisites to enabling RGA:

For administrators:

Ensure that each user's firewall doesn't block "ai.redgate.cloud" on port "443" (https).
If you have created a Redgate organization before, ensure you have opted-in to use AI features in Redgate portal. To find out more about the Redgate organization authentication, refer to Creating a Redgate Organization.
Navigate to Configuration > AI settings and enable the toggle switch under Redgate Assistant.

For other users:

You will need to create your Redgate ID, follow instructions on how to Create and manage your Redgate ID.

Disabling Redgate Assistant

To turn Redgate Assistant off for one Monitor instance, go to Configuration > AI settings and switch it off.

To turn AI features off for everyone in your organization — across Redgate Assistant and other Redgate products — see Managing AI features for your organization.

Launch RGA in Redgate Monitor

Navigate to Overview page and click the Redgate Assistant button to launch RGA.

Sign in

Type your Redgate ID credentials

Start chatting or click on one of our suggestions!

What can RGA do?

Currently RGA can do the following:

Tool name	Tool description
get_base_monitors	Lists the connected base monitors in the installation.
get_monitored_servers	Lists monitored servers for a base monitor, with identifiers and monitoring status.
get_metrics	Returns time-series metric data (for example CPU usage) for a monitored server.
get_sql_server_top_queries	Returns the top SQL Server queries by resource usage for a time range.
get_sql_server_top_waits	Returns the top SQL Server wait types for a time range.
get_sql_server_queries_per_wait	Returns the queries contributing to a specific SQL Server wait type for a time range.
get_sql_server_estimated_query_plan	Returns the estimated execution plan for a query.
get_sql_server_actual_query_plan	Returns the most recent actual (post-execution) plan captured for a query.
get_alerts	Returns alerts raised within a time window, including type, status, and severity.
get_alert_details	Returns the full details of a single alert.
get_monitor_documentation	Points the assistant at the Redgate Monitor documentation for questions the data tools can't answer.

FAQ:

Are users and groups permissions reflected in RGA?
RGA works along with all authentication types in Monitor. User with restricted access to servers will only be permitted to query their allowed instances.