May 8, 2007 at 11:42 pm
I took too long writing this the first time and all my work got tossed out when I hit "post new topic".
So, I'll keep it short:
Job running too long, SQL agent ran a process called "DbccFilesCompact" that was taking lots of CPUs. Is this related to DBCC SHRINKFILE?
The DB still seems to have space to grow. Would it run shrinkfile on itself if some space limit were reached?
Thanks!
May 9, 2007 at 12:01 am
I think so..
If the AUTO SHRINK database option is enabled, it will shrink automatically based on the free space other wise not...
MohammedU
Microsoft SQL Server MVP
May 9, 2007 at 12:04 am
Hmm, Auto Shrink is off.
June 22, 2009 at 10:01 pm
I see the same thing when i run dbcc shrink file in 08.
June 22, 2009 at 10:43 pm
Just to be clear, you should not be regularly running shrinks. This is for emergencies only. Keep free space in your files to handle normal operations.
June 26, 2009 at 12:32 pm
I only use it on our support environments after my nightly restores.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply