Synapse Studio - The monitor does not show queries about sql on demand

Question

The monitor does not show queries about sql on demand. In addition I have tried to execute the following query:

SELECT * FROM sys.dm_external_data_processed

and it returns this error: There is insufficient system memory in resource pool 'VDWFrontendPool' to run this query.

Answer 1

Hello @Richard Luis Díaz ,

Welcome to the Microsoft Q&A platform.

It’s an intermittent issue. I would suggest you re-try again and check if that works.

In case, if you are facing the same issue, please do share the screenshot of the error message.

I'm able to see how much data was processed during the current day, week, or month, execute the following T-SQL statement:

SELECT * FROM sys.dm_external_data_processed  

Hope this helps. Do let us know if you any further queries.

------------

• Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
• Want a reminder to come back and check responses? Here is how to subscribe to a notification.

Answer 2

Hello @Richard Luis Díaz ,

The product team had confirmed that this is a known issue, and they are working on a fix.

Queried view sys.dm_external_data_processed is using the underlying sys.dm_exec_requests_history which causes OOM when there are many queries in query history table.

Hope this helps. Do let us know if you any further queries.

------------

• Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
• Want a reminder to come back and check responses? Here is how to subscribe to a notification.