RE: Database Size question

  • From: "Michael B. Smith" <michael@xxxxxxxxxx>
  • To: "[ExchangeList]" <exchangelist@xxxxxxxxxxxxx>
  • Date: Thu, 19 Jan 2006 15:52:14 -0500

Whitespace/free space/unused database space - it's all the same. The
consolidation and reporting of same is a part of normal DB maintenance,
which comprises around a dozen steps.

 

Whitespace fluctuates as messages arrive and are deleted and SIS is
broken and deleted item retention takes places and free-space
consolidation works better because of any of the prior steps - etc. etc.
etc.

 

When available whitespace hits zero - then the database expands. As long
as whitespace is available, the database doesn't expand.

 

(Note that the above is a gross oversimplification of the algorithms
involved, but is, in general, accurate.)

 

________________________________

From: Ralph Haney [mailto:rhaney@xxxxxxxxxxxxxxxxxx] 
Sent: Thursday, January 19, 2006 3:27 PM
To: [ExchangeList]
Subject: [exchangelist] RE: Database Size question
Sensitivity: Private

 

http://www.MSExchange.org/

    <RANT BLOCK ON>

    Not having formal Exchange (or even messaging training) and wearing
so many IT/operations hats I often don't have time to do extensive
research, may I ask a question on free space?

    Based on your suggestion, I took a look out of curiosity and my
application logs for ID 1221 seem to fluctuate with freespace values
from about a half-gig to only 3-4 MB after an online defrag completes.

 

    1) I assume this is the normal DB maintenance occurring and is
nothing to be concerned about...?

    2) This is the term "whitespace" that you're referring to?

 

    TIA

 

    <RANT BLOCK OFF>

 

    

Ralph Haney MCSE
IT / Telecom Manager

Avalon Natural Products

www.avalonnaturalproducts.com
 
<http://204.202.2.54/coop.avalonnaturalproducts.com/MCSE-RGB_small4.gif>


 

    

 

 

        -----Original Message-----
        From: Michael B. Smith [mailto:michael@xxxxxxxxxx]
        Sent: Thursday, January 19, 2006 11:54 AM
        To: [ExchangeList]
        Subject: [exchangelist] RE: Database Size question
        Sensitivity: Private

        http://www.MSExchange.org/

        Whitespace. 

         

        Previously used space stays in the database.

         

        Unless you have a need to do an offline defrag (and based on the
information you've presented here, I wouldn't say that you do), don't do
one.

         

________________________________

        From: Rich Gallo [mailto:RGallo@xxxxxxxxxxxxxxxxx] 
        Sent: Thursday, January 19, 2006 2:42 PM
        To: [ExchangeList]
        Subject: [exchangelist] Database Size question
        Sensitivity: Private

         

        http://www.MSExchange.org/

        I was comparing the size of my database backups to my mailbox
level backups and I found a discrepancy of about 10 Gigs (Database is 35
GB Mailboxes are 25 GB).  Is there some kind of overhead to the database
that I am missing??  Should I do an offline defrag of the stores? Just
curious, nothing earth shattering J  Thanks!!!

         

        Also, there usually aren't many log files because I do a full
backup every night and also each day an Incremental is done every two
hours. In other words, I don't believe log files account for the
difference.

         

         

        ------------------------------------------------------
        List Archives:
http://www.webelists.com/cgi/lyris.pl?enter=exchangelist
        Exchange
<http://www.webelists.com/cgi/lyris.pl?enter=exchangelist%0bExchange>
Newsletters: http://www.msexchange.org/pages/newsletter.asp 
        ------------------------------------------------------
        Visit TechGenix.com for more information about our other sites:
        http://www.techgenix.com
        ------------------------------------------------------
        You
<http://www.techgenix.com%0b--------------------------------------------
----------%0bYou>  are currently subscribed to this MSExchange.org
Discussion List as: michael@xxxxxxxxxx
        To <mailto:michael@xxxxxxxxxx%0bTo>  unsubscribe visit
http://www.webelists.com/cgi/lyris.pl?enter=exchangelist
        Report
<http://www.webelists.com/cgi/lyris.pl?enter=exchangelist%0bReport>
abuse to info@xxxxxxxxxxxxxx 

         

        --
        No virus found in this outgoing message.
        Checked by AVG Free Edition.
        Version: 7.1.375 / Virus Database: 267.14.21/235 - Release Date:
1/19/2006

        ------------------------------------------------------
        List Archives:
http://www.webelists.com/cgi/lyris.pl?enter=exchangelist
        Exchange
<http://www.webelists.com/cgi/lyris.pl?enter=exchangelist%0bExchange>
Newsletters: http://www.msexchange.org/pages/newsletter.asp 
        ------------------------------------------------------
        Visit TechGenix.com for more information about our other sites:
        http://www.techgenix.com
        ------------------------------------------------------
        You
<http://www.techgenix.com%0b--------------------------------------------
----------%0bYou>  are currently subscribed to this MSExchange.org
Discussion List as: rhaney@xxxxxxxxxxxxxxxxxx
        To <mailto:rhaney@xxxxxxxxxxxxxxxxxx%0bTo>  unsubscribe visit
http://www.webelists.com/cgi/lyris.pl?enter=exchangelist
        Report
<http://www.webelists.com/cgi/lyris.pl?enter=exchangelist%0bReport>
abuse to info@xxxxxxxxxxxxxx 

------------------------------------------------------
List Archives: http://www.webelists.com/cgi/lyris.pl?enter=exchangelist
Exchange
<http://www.webelists.com/cgi/lyris.pl?enter=exchangelist%0bExchange>
Newsletters: http://www.msexchange.org/pages/newsletter.asp 
------------------------------------------------------
Visit TechGenix.com for more information about our other sites:
http://www.techgenix.com
------------------------------------------------------
You
<http://www.techgenix.com%0b--------------------------------------------
----------%0bYou>  are currently subscribed to this MSExchange.org
Discussion List as: michael@xxxxxxxxxx
To <mailto:michael@xxxxxxxxxx%0bTo>  unsubscribe visit
http://www.webelists.com/cgi/lyris.pl?enter=exchangelist
Report
<http://www.webelists.com/cgi/lyris.pl?enter=exchangelist%0bReport>
abuse to info@xxxxxxxxxxxxxx 

Other related posts: