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

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

05/19/2026

01:00 PM

05/19/2026

Establishing a Robust AI Governance Framework for GenAI Throughout Deployment Phases

https://www.truthinit.com/index.php/channel/1936/establishing-a-robust-ai-governance-framework-for-genai-throughout-deployment-phases/
05/20/2026

08:00 AM

05/20/2026

Establishing a Robust AI Governance Framework for GenAI Throughout Its Lifecycle

https://www.truthinit.com/index.php/channel/1937/establishing-a-robust-ai-governance-framework-for-genai-throughout-its-lifecycle/
05/20/2026

10:00 PM

05/20/2026

Establishing a Robust AI Governance Framework for GenAI Throughout Its Lifecycle

https://www.truthinit.com/index.php/channel/1953/establishing-a-robust-ai-governance-framework-for-genai-throughout-its-lifecycle/
05/21/2026

11:00 AM

05/21/2026

The Autonomous Era: Orchestrating a Resilient Enterprise

https://www.truthinit.com/index.php/channel/1372/the-autonomous-era-orchestrating-a-resilient-enterprise/
05/27/2026

04:00 AM

05/27/2026

Rivoluziona i rischi dell'AI in opportunità con Netskope AI Security

https://www.truthinit.com/index.php/channel/1925/rivoluziona-i-rischi-dellai-in-opportunità-con-netskope-ai-security/
05/27/2026

10:00 AM

05/27/2026

Adopting AI: From Illusion to Intentional Control

https://www.truthinit.com/index.php/channel/1924/harnessing-ai-transitioning-from-illusion-to-purposeful-mastery/
05/28/2026

01:00 PM

05/28/2026

Harnessing AI for Smaller Teams: Strategies for Secure Implementation

https://www.truthinit.com/index.php/channel/1951/harnessing-ai-for-smaller-teams-strategies-for-secure-implementation/
06/02/2026

01:00 PM

06/02/2026

Spring of Satori: Delving into Recent Findings and 2026's Threat Landscape

https://www.truthinit.com/index.php/channel/1930/spring-of-satori-delving-into-recent-findings-and-2026s-threat-landscape/
06/04/2026

02:00 AM

06/04/2026

Mastering the Unseen: Managing Shadow AI and Agentic MCP Traffic

https://www.truthinit.com/index.php/channel/1948/mastering-the-unseen-managing-shadow-ai-and-agentic-mcp-traffic/
06/16/2026

07:00 AM

06/16/2026

Transforming Data Risk into Actionable Priorities: Essential Fixes First

https://www.truthinit.com/index.php/channel/1952/transforming-data-risk-into-actionable-priorities-essential-fixes-first/