SQL Server Performance

DBCC shrinkfile cost OS resource?

Discussion in 'SQL Server 2005 General DBA Questions' started by georgej, Jul 23, 2007.

  1. georgej New Member

    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
  2. MohammedU New Member

    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.
  3. satya Moderator

    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.
  4. georgej New Member

    Thanks for all of your help!
  5. satya Moderator

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

Share This Page