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

Question

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

Answer 1

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.