July 25, 2006 at 8:44 am
Hi all,
I shrinked my database last week, it has around 2 Terrabytes of data on it, but i found myself having to shrink it, the shrink rate was 1GB an Hour.
This is not good enough for me, as it means i free up so little space in a long time, what can i do to resolve this ? or is it normal ?
Thanks in advance
John
July 25, 2006 at 10:43 pm
Shrinks are slow. They typically have to move a lot of data from near the end of the file to the beginning. Every data movement is logged, so shrinks hit the logfiles a lot. Placing the logfiles on fast arrays separate from the datafiles helps.
How many datafiles are you using? Are you running SHRINKDB or SHRINKFILE? Processing one file at a time won't help the overall throughput, but it can help you break the processing into smaller chunks to minimize server impact.
July 26, 2006 at 3:26 pm
Dbcc shrink file works faster since it works on file by file basis and the changes are permanently stored as it completed the single file operation. This is not a general recommended practice rather it should be used during the problematic period on case by case basis. Such as Transaction log file growing to a huge extent than the Data file size.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply