Insufficient memory when running script/stored procedure activity using synapse

Jovian Aditya Wiranata 0 Reputation points
2024-04-23T08:36:35.47+00:00

So serverless sql have a limit memory of data processed?

I got the error message like this:
Operation on target Stored procedure1 failed: Execution fail against sql server. Please contact SQL Server team if you need further support. Sql error number: 24710. Error Message: There is insufficient system memory to read the data: file

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,482 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,769 questions
{count} votes

1 answer

Sort by: Most helpful
  1. PRADEEPCHEEKATLA-MSFT 80,096 Reputation points Microsoft Employee
    2024-04-23T09:51:19.34+00:00

    @Jovian Aditya Wiranata - Thanks for the question and using MS Q&A platform.

    Yes, Serverless SQL pools in Azure Synapse Analytics have a limit on the amount of memory that can be used to process data. The maximum size of query result sets in Serverless SQL pools has been increased from 200 GB to 400 GB, but this limit is shared between concurrent queries.

    In your case, the error message indicates that there is insufficient system memory to read the data. This could be due to the amount of data being processed or the complexity of the query. You may need to optimize your query or consider using a dedicated SQL pool with more memory if you need to process larger amounts of data.

    For more details, refer to Troubleshoot serverless SQL pool in Azure Synapse Analytics.

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

    0 comments No comments