If you are seeing SQL statements in DPA that resemble "FETCH API_CURSORXXXXXXXXXXX" or "exec sp_cursorfetch 180150003,32,1,1", these typically indicate the use of server-side cursors.
To investigate further, locate the SPID executing these statements. You can do this in DPA’s Sessions tab for the query:
Alternatively, you can use the Show Active Sessions link from the Current tab as well.
Analysis Query
Once you have the SPID, you can run the following query against the monitored target to examine the underlying SQL:
SELECT c.properties, c.creation_time, c.is_open, t.text
FROM sys.dm_exec_cursors (53) c
CROSS APPLY sys.dm_exec_sql_text (c.sql_handle) t