DPA showing a high wait query with all info except query text

Question

We are using DPA version 12.0.3083.  We are tracking a performance issue an hour earlier and found a few queries having some wait time.  Using the drill-down, we are able to see the query context except one.  This particular one would only show 'Sql Statement not available'.   From other DPA info, we know it is a query from our web server but why it can't show the query context.  Can someone shred some light on this?   This doesn't happen often to us.  In fact, we haven't encountered this 'sql statement not available' for a long while.

darichar · Answer

Is this a SQL Server instance where you see this? If so, have you tried any of the suggestions above to capture the sql_handle?

wing · Answer

Thanks for replying.   The query that in question is a frequently executed one like at least 100 times per hour.    Would your explanation still apply?

More details here, during the troubleshooting time,  when DPA reported a high wait time under a particular session ID, there were also various other queries running under the same session ID.  Since there was one particular one which ran the longest (5~7 secs) (the frequently run one), I assume this was the one DPA trying to capture and display the query text.    There were a few others by this session ID run under 1 or 2 secs.   If your reason for DPA not able to display a query text is for non-frequently run query, my situation here would have to be for another query DPA trying to display a query context not the longest one and frequently run query I found.

jaminsql · Answer

I would also suggest you upvote this item

It would help as you then wouldn't have to do all the extra logging steps to get this data to see what is happening here.