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

Richard Luis Díaz 21 Reputation points
2020-12-19T01:23:33.493+00:00

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.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,319 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. PRADEEPCHEEKATLA-MSFT 76,361 Reputation points Microsoft Employee
    2020-12-21T08:22:45.457+00:00

    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  
    

    49767-image.png

    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.

  2. PRADEEPCHEEKATLA-MSFT 76,361 Reputation points Microsoft Employee
    2021-01-06T10:30:30.867+00:00

    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.
    0 comments No comments