Windows IT Pro is the leading independent community for IT professionals deploying Microsoft Windows server and client applications and technologies.
  
  
  Advanced Search 


December 22, 2005

Dealing with Databases

Increase the effectiveness of your defrag decsions
RSS
View this exclusive article with VIP access -- click here to join |
See More Database Articles Here | Reprints | Or sign up for our VIP Monthly Pass!

When the Time Comes to Defrag
Because Exchange I/O operations to databases tend to be random, a large contiguous database file isn't as crucial to good I/O performance as would be the case if large sequential reads and writes were necessary. Still, if the volume that holds your Exchange database has a high level of fragmentation, you should defrag the volume. If you don't use specialized third-party disk-defrag software, you can run the standard Disk Defragmenter tool (under Start, All Programs, Accessories, System Tools).

Be sure not to run a disk-defrag program on a production Exchange server during working hours or while a database is mounted (in which case Windows can't defrag the file). Disk defrags are I/O-intensive operations and will affect the performance of the Exchange system: Exchange I/O operations will take inordinate amounts of time to complete. For the best results, take the following steps to perform a file-system defrag:

  1. Dismount the Exchange databases.
  2. Copy the databases to another volume.
  3. Perform the disk defrag on the original volume.
  4. Copy the Exchange databases back to the original volume. (The act of copying the database between volumes will implicitly defrag the database at the file-system level but won't affect internal white space.)

Database Changes in Exchange 2003 SP2
Exchange 2003 Enterprise Edition effectively has no upper limits on database size. However, Exchange 2003 Standard Edition has had an upper limit of 16GB on the single permitted Exchange database. This 16GB size limit is based on the actual size of the Exchange Database (EDB) file reported by the file system, so if you're approaching this limit, check the amount of white space in the database to determine whether an offline defrag might considerably reduce the database file size. (Bear in mind that an offline defrag operation that uses Eseutil requires that the volume have additional free space of as much as 120 percent of the database size to hold the temporary files created during the defrag.) . . .


Already a VIP member?
Please log on to view the full article

Why become a VIP member?

VIP-only online access
VIP CD delivered twice a year: offline access to the entire Windows IT Pro article library
Monthly issue of your choice of Windows IT Pro or SQL Server Magazine

Subscribe Now
Reader Comments
Great information for me to understand the importance of letting Exchange take care of itself with online defrags!

I'd like some clarification about two of the steps you listed for performing a file-system defrag when your Exchange stores are on a highly fragmented volume.

(step 2.) When you copy the stores to another volume, do you just simply make a straight copy of them, or is this really a cut-n-paste operation to remove the stores from the volume entirely?

(step 4.) When you copy the databases back to the newly defragmented volume, are you supposed to overwrite the original files?

Thanks!
- Kirstin

oohgodyeah January 18, 2006 (Article Rating: )


You must be a registered user or online subscriber to comment on this article. Please log on before posting a comment. Are you a new visitor? Register now




Top Viewed ArticlesView all articles
WinInfo Short Takes: Week of November 9, 2009

An often irreverent look at some of the week's other news, including some more Windows 7 sales momentum, some Sophos stupidity, Microsoft's cloud computing self-loathing, more whining from the browser makers, Zoho's "Fake Office," and much, much more ...

Command Prompt Tricks

One reader shares his tip for setting up the command prompt to reflect a remote path. ...

Windows 7 Sets Sales Record

Microsoft CEO Steve Ballmer described Windows 7's first ten days of sales as "fantastic" while in Japan yesterday. ...


Exchange Server and Outlook Whitepapers Take Control of Your Email: Understand the Business Reasons for Email Storage Management

Continuous Data Protection and Recovery for Microsoft Exchange

Related Events WinConnections and Microsoft® Exchange Connections

Check out our list of Free Email Newsletters!

Exchange Server and Outlook eBooks Spam Fighting and Email Security for the 21st Century

Understanding and Leveraging Code Signing Technologies

The Expert's Guide for Exchange 2003: Preparing for, Moving to, and Supporting Exchange Server 2003

Related Exchange Server and Outlook Resources Introducing Left-Brain.com, the online IT bookstore
Looking for books, CDs, toolkits, eBooks? Prime your mind at Left-Brain.com

Discover Windows IT Pro eLearning Series!
Clear & detailed technical information and helpful how-to's, all in our trademark no-nonsense format

Exchange & Outlook UPDATE eNewsletter
News, strategies, products, and developments in Exchange Server and Outlook messaging.

Windows IT Pro Home Register FAQ for Windows WinInfo News
Europe Edition About Us Contact Us/Customer Service Media Kit Affiliates / Licensing  
SQL Server Magazine Office & SharePoint Pro DevProConnections IT Job Hound
Left-Brain.com Technology Resource Directory asp.netPRO ITTV Windows SuperSite 
 
 Windows IT Pro is a Division of Penton Media Inc.
 © 2009 Penton Media, Inc. Terms of Use | Privacy Statement