Benefits of Offline defrag

Posted on 2008-11-17
Last Modified: 2012-05-05
Hi Experts

We are running Exchange 2003 SP2.

We have about 1000 users per server.

We haven't run any offline defrags since I joined the company about a year ago, and I was wondering what people's opinions were on this.

Is there anyway to tell if an Offline defrag would benefit us? And what benefits do offline defrags actually give?

Question by:bruce_77
    LVL 9

    Assisted Solution

    yes the event viewer creates an entry that tells you how much free space is in the database.
    conventional wizdom is that it only helps if you delete a large amount of data in bulk.

    if you delete a mailbox now and then it will not matter for the following reason.

    you delete a user who has 50 meg of mail.
    over the course of the next few weeks users save more mail.
    the online defrag recovers the space inside the db.  the new mail being saved takes up this space, and the offline defrag is a very temporary gain.

    LVL 6

    Assisted Solution

    You really only need to run an offline defrag if you make a major change to the database, such as moving a lot of users out of the db, or a lot of users are deleted or you run a hard repair against the db, but for normal operation it is better to leave the whitespace for the db to use when needed.
    LVL 58

    Accepted Solution


    The only time an offline defrag will be of benefit is when you have archived or deleted a large amount of data from a mail store, or if you have moved a lot of data off to other mail stores. As you know, Exchange marks the data it frees up from such operations as 'whitespace', so the capacity remains allocated to the database files on disk, but is not actually being used to store any mail. It is just redundant space waiting to be used as and when it is needed by some incoming email.

    If you have performed any of these operations already mentioned, you would benefit from an offline defrag since it would reduce the physical size of the mail store, enabling you to use that disk space for other things. It also gives you the chance to let Exchange re-organise the database since it can become quite fragmented over time.

    Remember that running an Offline Defrag could result in downtime of several hours on larger stores, since your databases must be dismounted during the time when it occurs. Preferably, I would suggest you dismounted all databases on the disk array where the database being offline defrag'ed resides, since the constant I/O from Exchange coupled with the offline defrag's I/O could cause potential issues.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Use email signature images to promote corporate certifications and industry awards.
    "Migrate" an SMTP relay receive connector to a new server using info from an old server.
    In this video we show how to create a User Mailbox in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Recipients >> Mailb…
    The video tutorial explains the basics of the Exchange server Database Availability groups. The components of this video include: 1. Automatic Failover 2. Failover Clustering 3. Active Manager

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now