SQL Server Performance Forum – Threads Archive

DBCC SHRINKFILE w/ EMPTYFILE

Hi All, We have 4 sql db files on a single raid group that we want shrink into 1 db file. Each db file is ~37GB. According to BOL, DBCC SHRINKFILE w/ EMPTYFILE can be run while users are accessing/working in the database. What BOL doesn’t say is if there’s a performance hit to the users when you are shrinking a file. Personally, I think there would be but haven’t found anything quantifying the impact. Has anyone done this before while users were in the DB, or does anyone know of where I can find more info? Thanks, – Tony -Tony C.

Please: SQL Version and SP? Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell

Yes there will not be any impact on performance, but its always better to run during less traffic on the database to avoid unprecedented issues given in reference to the size of dbfile above. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

Sorry Luis, SQL 2000 and SP 2. -Tony C.

I don’t think SP is related in this regard.
(Apologies Luis if I’ve offended, but in anycase SHRINKFILE action is similar) _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

SQL 7.0 SP2 has a big bug using shrink. BTW: I have to install SQL2000 sp2 to fix, because with SQL 7.0 sp3 fix the bug but no the problem into database. Take it easy Satya[<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] . Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true. Bertrand Russell

Any TEXT/IMAGE columns involved in database? _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

Satya, Very few TEXT/IMAGE cols. and none that are very important. -Tony C.

Then make sure to watch the process of SHRINKFILE.
Also keep in mind the process of SHRINK is not immediate for Tlog.
_________
Satya SKJ
Moderator
SQL-Server-Performance.Com

Satya, What would I be looking for? and the recovery model for the db is set to simple, so would there be any reason care about the tlog? -Tony C.

I refer this KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;324432 which speaks about involvement of TEXT/IMAGE columns if you use SHRINKFILE method, fyi. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

Thanks to all of you for your help. -T -Tony C.

]]>