Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Load or query attempt triggers "filegroup is full" error in SQL Server APS

Load or query attempt triggers "filegroup is full" error in SQL Server APS

View products that this article applies to.

Symptoms

A load or query operation in Microsoft SQL Server APS fails because of a "filegroup is full" error that occurs in the specific distribution. The full error message resembles the following:
 
The server could not finish the load. Details:

Could not allocate space for object 'dbo.Table_afb37597193a4b17bb0737c5f92217fb_C' in database 'DB_6644d2917edb4df8adcc5639f61bbfda' because the 'DIST_C' filegroup is full.

↑ Back to the top

Cause

This issue is triggered by table data skew. The data skew percentage may be on the lower end of the scale. In our repro example, the data skew was only six percent for the top three tables. However, these percentages collectively take up 22 percent of the space that's allocated for that database. Additionally, this total does not take into account the data skew in other tables. Those percentages could be larger. 

↑ Back to the top

Resolution

To resolve this issue, expand the database appropriately, or run the following procedure:
ALTER DATABASE database_name SET (AUTOGROW=ON)

↑ Back to the top

Keywords: kb, kbprb

↑ Back to the top

Article Info
Article ID : 3171132
Revision : 8
Created on : 5/12/2017
Published on : 5/12/2017
Exists online : False
Views : 296