Shrinking file grows again

Question

Shrinking file grows again

balbirsinghsodhi

SSCrazy Eights

Points: 9210
More actions
August 10, 2009 at 8:38 am

#213265

I have partition on one of the table in which data is distributed to different filegroups. for example. I believe that these filegroups would not get updated because of the old date so I wanted to shrink these filegoups to get more space on the drive. when I shrink these filegroups,it shows filegroups are full but after two days it grows again and there is 50% space in the filegroups. My question is, why these filegroups grows again when there is no data insert or update in those filegroups.
MIN RANGE MAX RANGE FILEGROUP
> 12/31/1999 <= 03/01/2000 FILEGROUP1
> 03/01/2000 <= 09/30/2000 FILEGROUP2
> 09/30/2000 <= 12/31/2000 FILEGROUP3
--
--
--

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 1

balbirsinghsodhi (8/10/2009)
I have partition on one of the table in which data is distributed to different filegroups. for example. I believe that these filegroups would not get updated because of the old date so I wanted to shrink these filegoups to get more space on the drive. when I shrink these filegroups,it shows filegroups are full but after two days it grows again and there is 50% space in the filegroups. My question is, why these filegroups grows again when there is no data insert or update in those filegroups.
MIN RANGE MAX RANGE FILEGROUP
> 12/31/1999 03/01/2000 09/30/2000 <= 12/31/2000 FILEGROUP3
--
--
--

There are other things that can cause growth such as rebuilding indexes.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

VastSQL SSC-Dedicated Points: 36121 More actions · Answer 2

That may occur because those filegroups need that much space for proper functioning ..

Please check others advise too.

balbirsinghsodhi SSCrazy Eights Points: 9210 More actions · Answer 3

You guys are right, I just checked and found that db-reindex are running on those partition tables and growing the size of filegroups.

One more thing I noticed that DB-reindex is taking forever now. I think that is because of the shinking of the filegroup.

apprecited.

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 4

Shrinking the file after doing a reindex just messes things up because the shrink moves pages.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)