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.
