So here is an interesting example of using Quest solutions together. What if you have Foglight, you are monitoring a database, you find a SQL Server stored procedure that is getting slower, and slower and you want to know what the purpose of this proc? Ask AI?
Well yes you can, here are the steps.
I’ve created a scenario that all the SQL Server people can relate to, the Adventureworks sample database.
Spoiler here, I’ve contrived the code to make it slow, but I want you to see an explanation of the code that you can relate to, not something I’ve made up.
So, we find the GetBillOfMaterials procedure has a poor response time and wondering why. Normally in Foglight we could look at the particular queries in the procedure and look at the query performance and wait stats etc.
But I wanted to demonstrate how we could get an explanation of this procedure using AI.
Fortunately, we have Toad Data Studio Subscription installed with an AI license.
We connect to the database in question, navigate to the database and procedures, right click on the object and select AIExplain:
And this helpful explanation pops up:
Fantastic, imagine doing this on a larger procedure and wading through the code. Or if you are a developer and you are asked by the performance team to review this procedure and speed it up.
There is the ability to give the engine feedback, positive and negative as well as provide feedback in writing.
So, did you spot my deliberate sabotage?
Click here for further information on Foglight and Toad Data Studio.
