Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Find named SQL in DPA

Is there a way to find a named SQL statement in DPA? I have a specific SQL statement that I named at one point and I need to see metrics on it in DPA.

Thank you,

David

Find more posts tagged with

Accepted answers

All comments

dkranes

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

mandevil

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...

dkranes

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

mandevil

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