Could not allocate space for object dbo.xyz in database distribution_1

Nagesh CL 641 Reputation points
2023-05-17T10:51:40.2366667+00:00

Hi Team,

We are getting the below error while running Synapse pipelines. Target is dedicated sql pool. Right now the number of DWU is set to 500DWc.

Error - Could not allocate space for object dbo.xyz in database distribution_1 because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

Is the solution for this to increase the number of DWUs? Or is there a way to change the rcclass which increases the storage space? Also, is there a way to set the autogrowth properties and changing it will help resolve this error?

Thanks.

Regards,

Nagesh CL

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,667 questions
0 comments No comments
{count} votes

Accepted answer
  1. Vinodh247 13,226 Reputation points
    2023-05-17T12:45:38.6166667+00:00

    Hi

    Thanks for reaching out to Microsoft Q&A.

    Looks like you are running some heavy query which is making the tempdb full.

    Is the solution for this to increase the number of DWUs?

    Yes you can increase. For every DW100c configured 399 GB of TEMPDB space will be allocated...see below.

    https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-service-capacity-limits#workload-management

    Or is there a way to change the rcclass which increases the storage space?

    Resource class are pre-determined resource limit at user level and only manages the workloads, not the storage.

    The below link will be useful to your case as it has troubleshooting and mitigation steps for tempdb issues. You can use the query to find & kill the troublesome sessions as a quick fix.

    https://learn.microsoft.com/en-us/troubleshoot/azure/synapse-analytics/dedicated-sql/dsql-perf-tempdb-errors

    Please Upvote and Accept as answer if the reply was helpful, this will be helpful to other community members.

    0 comments No comments

0 additional answers

Sort by: Most helpful