Find named SQL in DPA

I have found the query plan in DPA for the query in question using a DPA report but I actually want to run an analysis on the SQL so I can see where it is being run from if possible.

Thank you,

David Kranes

When you have found the query, make sure you click on the query name or the hash for it. Then it should be added as part of your breadcrumbs (context near the top). From there, you can click through all the other dimensions including machines to see what client(s) are running it. Let me know if that doesn't help...

i have not actually found the query other than adding it to a custom Top Query Plan report.  When I look at all SQL for the day I know it ran on it is not included in the SQL Text list so it must be way down on the list and not displayed.

David

Oh, try doing a search for the name in reports for top SQL or maybe even in the SQL text for something about the statement that would be fairly selective.

You should be able to pull a report that can at least tell you what days it ran on and perhaps get a little more granular that that.

Also, here's a post that may help: finding SQL with a string

I found it but I still need to see who ran it and the SQL you provided in your linked post is not working.

might be easier to show you than describe it here. Would you be up for a screenshare?

Sure. Can we do this on Thursday some time? Thank you my friend.

David Kranes

P. (845)703-6491

C. (845)467-9217

email me - I'll send you and invite...

robert.mandeville@solarwinds.com

Great. Thank you.

David Kranes

P. (845)703-6491

C. (845)467-9217

When are you available? I have a 10:00AM ET meeting. Do you want to do it after that? I have the report set up with the query in question as a start.

Kind Regards,

David B. Kranes, OCSA, OCWA, ITIL | Senior Database & OnBase Administrator

Crystal Run Healthcare LLP