Should I implement AI-generated query optimizations without testing?

No. The presenter emphasizes a trust-but-verify approach, recommending that you always test AI suggestions first to ensure they make sense, are maintainable, and actually improve performance before deploying to production.

Solarwinds: AI-Powered SQL Query Optimization in SQL Sentry

Name: Solarwinds: AI-Powered SQL Query Optimization in SQL Sentry
Uploaded: 2026-03-29T07:26:24-04:00
Duration: 3 min 2 s
Description: TL;DR AI Query Assist in SQL Sentry uses generative AI to automatically rewrite inefficient SQL Server queries and suggest missing indexes in about one minute The system sanitizes query text and execution plans locally before sending to the AI engine, ...

Solarwinds

03/29/2026

0 (0%)

Report Like Favorite

Transcript

It is an advisor that will help you potentially rewrite a query. It will also help suggest missing indexes, etc., and it appears in the AI Query Assist column within the web portal. So this is something that is unique to the web portal itself. In this case, we've already done an optimization for this one, so you can see that it is waiting there for our review. If you want to do a new one, these are the ones that have both a SQL statement as well as a plan that we can send to the AI engine. So to do that, and you click on a query, there is a new AI Query Assist tab in the bottom right, and you would just choose Optimize SQL. What happens under the covers then is that a sanitized version of your SQL statement, so the text data, as well as the plan, is sent up to our AI query engine, and in about a minute or so, it will come back with the results. So let's take a quick look at some examples of results. So I did this optimization a couple of days ago, and it's very small down here, so what I typically will do is maximize this screen, and then you get four different sections of things. The top one is the rewritten query, so here is the original, and then here is the optimized version of that. Now as with any AI engine, I never take it at first blush. I make sure and test it first of all, and make sure that it makes sense to me that I can maintain it, and I really take it as more of a suggestion, maybe some different ideas on how to rewrite the query. A lot of us get stuck writing queries the same way oftentimes, but this might be another option that you didn't think about previously. The other sections, the thinking section, it gives you a little bit about what it saw and what it will work on and improve potentially. The explanation is a detailed explanation of what it found and kind of what it suggested doing, including there will be some suggested indexes potentially here. And then there's also a summary too of what it would do. So it hopefully will provide maybe a different way of thinking about the query, but hopefully ways of rewriting the query so that it is more optimal.

TL;DR

AI Query Assist in SQL Sentry uses generative AI to automatically rewrite inefficient SQL Server queries and suggest missing indexes in about one minute
The system sanitizes query text and execution plans locally before sending to the AI engine, masking PII to maintain security and compliance
Results include side-by-side comparison of original and optimized queries with detailed explanations of logic changes and performance improvement recommendations

Summary

This demonstration introduces AI Query Assist, a new generative AI feature in SolarWinds SQL Sentry that automates SQL query optimization for SQL Server environments. The feature analyzes problematic queries identified in the Top SQL view and generates optimized rewrites along with missing index recommendations in approximately one minute. The system sanitizes query text and execution plans locally before sending them to the AI engine, masking personally identifiable information to maintain security. Users can review the AI-generated suggestions through a dedicated interface that displays the original query alongside the optimized version, along with detailed explanations of the logic changes and reasoning behind the recommendations. The presenter emphasizes a trust-but-verify approach, encouraging database administrators to test and validate AI suggestions rather than implementing them blindly, positioning the tool as a way to discover alternative optimization approaches that might not have been considered using traditional manual tuning methods.

Chapters

0:00 - Introduction to AI Query Assist
0:34 - Accessing the Feature in Web Portal
1:02 - How Query Sanitization and Processing Works
1:22 - Reviewing AI-Generated Optimization Results

Key Quotes

1:02 "What happens under the covers then is that a sanitized version of your SQL statement, so the text data, as well as the plan, is sent up to our AI query engine, and in about a minute or so, it will come back with the results."
1:44 "Now as with any AI engine, I never take it at first blush. I make sure and test it first of all, and make sure that it makes sense to me that I can maintain it, and I really take it as more of a suggestion, maybe some different ideas on how to rewrite the query."
2:06 "A lot of us get stuck writing queries the same way oftentimes, but this might be another option that you didn't think about previously."

Categories:

» Data Protection » Backup & Recovery
» Data Protection

Tags:

Show more Show less

Browse videos

Upcoming Webinar Calendar

11/12/2026

01:00 PM

11/12/2026

Leaving VMware Means Leaving vSAN: Your VMware Exit Is Really a Storage Decision

https://www.truthinit.com/index.php/channel/2192/leaving-vmware-means-leaving-vsan-your-vmware-exit-is-really-a-storage-decision/
11/12/2026

01:00 PM

11/12/2026

Hands-On Workshop: Connecting On-Prem Data to Databricks Using MinIO AIStor (Americas)

https://www.truthinit.com/index.php/channel/2202/hands-on-workshop-connecting-on-prem-data-to-databricks-using-minio-aistor-americas/
11/18/2026

08:00 AM

11/18/2026

Practical Session: Connecting On-Prem Data to Databricks via MinIO AIStor (International)

https://www.truthinit.com/index.php/channel/2194/practical-session-connecting-on-prem-data-to-databricks-via-minio-aistor-international/
11/19/2026

01:00 PM

11/19/2026

Securing the Microsoft Enterprise: Strengthening Configuration Management, Identity Security, and Data Protection

https://www.truthinit.com/index.php/channel/2076/securing-the-microsoft-enterprise-strengthening-configuration-management-identity-security-and-data-protection/
11/19/2026

01:00 PM

11/19/2026

Zendesk Deep Dive: Get the work done faster with Employee Service AI Agents

https://www.truthinit.com/index.php/channel/2181/zendesk-deep-dive-get-the-work-done-faster-with-employee-service-ai-agents/
11/19/2026

01:00 PM

11/19/2026

A Deep Dive into Muse, Dots, and Duet's Impact on Your Website

https://www.truthinit.com/index.php/channel/2228/a-deep-dive-into-muse-dots-and-duets-impact-on-your-website/
12/03/2026

01:00 PM

12/03/2026

CISO Insights: Steering Cybersecurity Strategies in an AI-Driven Era

https://www.truthinit.com/index.php/channel/2231/ciso-insights-steering-cybersecurity-strategies-in-an-ai-driven-era/
01/19/2027

02:00 PM

01/19/2027

HUMAN Dialogue: Embracing the Rise of the Empowered AI Consumer.

https://www.truthinit.com/index.php/channel/2160/human-dialogue-embracing-the-rise-of-the-empowered-ai-consumer/
03/18/2027

01:00 PM

03/18/2027

Securing Access for People, Partners and AI Agents

https://www.truthinit.com/index.php/channel/2251/securing-access-for-people-partners-and-ai-agents/
06/17/2027

01:00 PM

06/17/2027

Stop the Leak: Data Loss Prevention for the AI Era

https://www.truthinit.com/index.php/channel/955/360view-stop-the-leak-data-loss-prevention-for-the-ai-era/
08/19/2027

01:00 PM

08/19/2027

Who Has Access to What...and Should They?

https://www.truthinit.com/index.php/channel/2252/who-has-access-to-what-and-should-they/
10/21/2027

01:00 PM

10/21/2027

After VMware: Building the Private Cloud You Actually Want

https://www.truthinit.com/index.php/channel/2253/after-vmware-building-the-private-cloud-you-actually-want/
11/18/2027

01:00 PM

11/18/2027

Assume Breach, Prove Recovery

https://www.truthinit.com/index.php/channel/2254/assume-breach-prove-recovery/
12/16/2027

01:00 PM

12/16/2027

The Self-Running Service Desk

https://www.truthinit.com/index.php/channel/2255/the-self-running-service-desk/