RE: Database Size question
- From: "Ralph Haney" <rhaney@xxxxxxxxxxxxxxxxxx>
- To: "[ExchangeList]" <exchangelist@xxxxxxxxxxxxx>
- Date: Thu, 19 Jan 2006 13:26:31 -0800
Great, thanks for the (simplified) explanation. I'm pleading my case for EX
training but hitting a budgetary wall at present. Prior to the SP2 install I
had to do a couple of off-line defrags before hitting that notorious Standard
Version DB limit -- but I assumed this was normal behavior.
(George, I embed the link code instead of the image so the MS logo doesn't come
across as an attachment on some clients. Plus, MS has very specific rules
regarding usage etc. No, I don't "need" to have it in there but I worked my *ss
off for that and have no reservations using it.)
~ Ralph
-----Original Message-----
From: Michael B. Smith [mailto:michael@xxxxxxxxxx]
Sent: Thursday, January 19, 2006 12:52 PM
To: [ExchangeList]
Subject: [exchangelist] RE: Database Size question
Sensitivity: Private
http://www.MSExchange.org/
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
-----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
<http://www.webelists.com/cgi/lyris.pl?enter=exchangelist%0bExchange>
Exchange Newsletters: http://www.msexchange.org/pages/newsletter.asp
------------------------------------------------------
Visit TechGenix.com for more information about our other sites:
http://www.techgenix.com
<http://www.techgenix.com%0b------------------------------------------------------%0bYou>
------------------------------------------------------
You are currently subscribed to this MSExchange.org Discussion List as:
michael@xxxxxxxxxx <mailto:michael@xxxxxxxxxx%0bTo>
To unsubscribe visit http://www.webelists.com/cgi/lyris.pl?enter=exchangelist
<http://www.webelists.com/cgi/lyris.pl?enter=exchangelist%0bReport>
Report 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
<http://www.webelists.com/cgi/lyris.pl?enter=exchangelist%0bExchange>
Exchange Newsletters: http://www.msexchange.org/pages/newsletter.asp
------------------------------------------------------
Visit TechGenix.com for more information about our other sites:
http://www.techgenix.com
<http://www.techgenix.com%0b------------------------------------------------------%0bYou>
------------------------------------------------------
You are currently subscribed to this MSExchange.org Discussion List as:
rhaney@xxxxxxxxxxxxxxxxxx <mailto:rhaney@xxxxxxxxxxxxxxxxxx%0bTo>
To unsubscribe visit http://www.webelists.com/cgi/lyris.pl?enter=exchangelist
<http://www.webelists.com/cgi/lyris.pl?enter=exchangelist%0bReport>
Report abuse to info@xxxxxxxxxxxxxx
------------------------------------------------------
List Archives: http://www.webelists.com/cgi/lyris.pl?enter=exchangelist
<http://www.webelists.com/cgi/lyris.pl?enter=exchangelist%0bExchange>
Exchange Newsletters: http://www.msexchange.org/pages/newsletter.asp
------------------------------------------------------
Visit TechGenix.com for more information about our other sites:
http://www.techgenix.com
<http://www.techgenix.com%0b------------------------------------------------------%0bYou>
------------------------------------------------------
You are currently subscribed to this MSExchange.org Discussion List as:
michael@xxxxxxxxxx <mailto:michael@xxxxxxxxxx%0bTo>
To unsubscribe visit http://www.webelists.com/cgi/lyris.pl?enter=exchangelist
<http://www.webelists.com/cgi/lyris.pl?enter=exchangelist%0bReport>
Report abuse to info@xxxxxxxxxxxxxx
------------------------------------------------------
List Archives: http://www.webelists.com/cgi/lyris.pl?enter=exchangelist
Exchange Newsletters: http://www.msexchange.org/pages/newsletter.asp
------------------------------------------------------
Visit TechGenix.com for more information about our other sites:
http://www.techgenix.com
------------------------------------------------------
You are currently subscribed to this MSExchange.org Discussion List as:
rhaney@xxxxxxxxxxxxxxxxxx
To unsubscribe visit http://www.webelists.com/cgi/lyris.pl?enter=exchangelist
Report abuse to info@xxxxxxxxxxxxxx
Other related posts:
