sp_BlitzLocke: add @AskAI parameter to get query plan advice #3671
Description
Is your feature request related to a problem? Please describe.
My apps don't have AI, and all the cool kids' apps do.
Just kidding. I'm looking for an easy way to send a deadlock graph to AI and get quick advice using SQL Server 2025's new stored proc to call LLMs.
Describe the solution you'd like
Add an @askai parameter. When set to 1, the result set needs to be filtered to just one row - we only wanna send a single request to AI due to the cost of the whole thing, so the user needs to be asking for one deadlock, and we just take the top 1 result row.
More design thoughts: https://www.brentozar.com/archive/2025/04/building-ai-calls-into-the-first-responder-kit/
Are you ready to build the code for the feature?
Yes, not coding it yet, but just adding this as a placeholder for design notes as I think about it over time.