SQL Server Performance Forum – Threads Archive

DBCC shrinkfile cost OS resource?

I run DBCC Shrinkfile command on my SQL 2005 server.
Does DBCC shrinkfile requires OS resources, such as memory, CPU usage?
How much does it cost? Thanks,
George

I don’t think it uses much cpu resources but it disk activity will be increased becuase it has to move the data before shrinking…
DBCC shrinkfile is less resource intensive incase if you cancel it will not take to rollback…
MohammedU.
Microsoft SQL Server MVP
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

SYSMON is the best resource to let you know what it is using, to my knowledge yes it uses CPU & Memoyr in addition to disk catering. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
@http://www.askasqlguru.com/ This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Thanks for all of your help!

…again see thishttp://msdn2.microsoft.com/en-us/library/ms189493.aspx BOL entry for the causes of blocking during SHRINK operation. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
@http://www.askasqlguru.com/ This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

]]>