Does DPA capture batch executed stored procedures?

We capture the individual SQL Statements that may run from a SProc. However, if you would like ot see overall impact of top SProcs running in your env, try this custom query against the repo:  Custom Report - Top Stored Procedures 

We capture the individual SQL Statements that may run from a SProc. However, if you would like ot see overall impact of top SProcs running in your env, try this custom query against the repo:  Custom Report - Top Stored Procedures 

Hi mandevil - thanks for your response. However, issue here is not pulling the report for top procedures. But to have DPA capture the SP's or individula SQL statements run from that Batch.
Does it have to do anything with permissions?

No, it's actually methodology. We do sampling, so can't tie anything caught in-flight with a specific batch run. You might want to look at Database Insights where you can add SQL Sentry which would capture the sproc runs... Since you already have DPA, it's extremely cost effective.

Well, I am sure we do not have Sentry in our environment. I have raised a case, so lets see if they can provide any insights to it.