DBCC shrinkfile cost OS resource? | SQL Server Performance Forums

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.
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |