Getting error: Execution fail against sql server. Please contact SQL Server team if you need further support. Sql error number: 701

Shemshetty, Saicharan 11 Reputation points
2023-01-16T12:19:59.7566667+00:00

We are trying to copy a data from a table that is present in dedicated sql pool to a target table present in the same pool.

This activity we are doing using Azure Data Factory.

We faced an error,

User configuration issue

DetailsExecution fail against sql server. Please contact SQL Server team if you need further support. Sql error number: 701. Error Message: There is insufficient system memory in resource pool 'smallrc' to run this query.

I tried searching for this error, but could not find proper answer.

Expecting some more details on this error and how to tackle it.

Thank you

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,314 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,136 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Bjoern Peters 8,776 Reputation points
    2023-01-16T12:48:16.7633333+00:00

    Hi

    Maybe you can find more information on the memory usage of your problem:

    SELECT * FROM sys.dm_external_data_processed  
    

    95192-image.png

    I hope my answer is helpful to you,

    Your

    Bjoern Peters

    If the reply was helpful, please upvote and/or accept it as an answer, as this helps others in the community with similar questions. Thanks!


  2. CosmogHong-MSFT 20,901 Reputation points Microsoft Vendor
    2023-01-17T02:24:51.6533333+00:00

    Hi @Shemshetty, Saicharan

    Try increase the memory:

    sp_configure 'show advanced options', 1;
    
    GO
    
    RECONFIGURE;
    
    GO
    
    sp_configure 'max server memory', 12288;
    
    GO
    
    RECONFIGURE;
    
    GO
    

    And then restart the Sql Server service.

    Make sure the max memory available for SQL Server is capped such that there is still memory available for OS. For example, if total available RAM is 8 GB, cap the total memory available to SQL Server is 6 GB.

    Best regards,

    Cosmog Hong


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments