Post reply

Defrag Server machine

  • January 10, 2011 at 5:00 am

    #245154

    Hi All,

    As a DBA of the company I am suppose to schedule a plan for defragment of my server .

    The server has less space and I cannot delete any data.

    I am confused as what steps to follow?

    The steps what is being noted by ex-dba is

    1. defrag the server.

    2. rebuild the index.

    3. defrag the server.

    etc... checking of site working/links etc.

    I am not confident with the values returned by DBCC showcontig as I am not getting clear as what it really means. I have read the BOL but I am still not able to judge whether to use reindex or not.

    I need to know

    1. how to determine from the result of dbcc showcontig whether I have to reindex.

    2. Which is better DBCC reindex or defrag the index.

    3. How frequently should i schdule for defragment, and also when to restart the main server machine, before or after defrag.

    If anything else I have not added for the checklist please do tell me.

    Thanks,

    Harsha:-)

  • January 10, 2011 at 5:41 am

    #1271330

    Duplicate post. No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1045215-5-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply