Avatar of EnvisionTech
EnvisionTech asked on

Exchange Database Size

We've got a Win SBS 2003 SP2 server.  Were running MS exchange and have noticed that there is quite a discrepancy between the size of the mailboxes shown within Exchange System Manager and the priv1.edb file.  Adding the mailboxes in System Manager, we get about 8GB of space, but the priv1.edb file is about 14gb.  I know that they won't ever match in size but I'm concerned about how far apart they are.  We've ran an offline defrag but it doesn't appear to shrink down the priv1.edb file at all.  Can anyone shed some light on weather I need to be concerned and what I should be doing about this situation?
ExchangeSBS

Avatar of undefined
Last Comment
EnvisionTech

8/22/2022 - Mon
Ehab Salem

Look for event id 1211 an application log, this will tell you how much free space is available in the edb file. The edb file never gets smaller untill you make an offine defrag for it.
rakeshmiglani

the size difference could be due to deleted items in the dumpster.
rakeshmiglani

Single instance storage can also make the mailbox size not match with the database size.  One message sent to multiple users is stored only one time in the database.  Each mailbox just has a pointer to that message, and the message is not deleted from the database until it has been deleted from all of the mailboxes.
check http://support.microsoft.com/default.aspx?scid=kb;en-us;175481 to know more about single instance storage
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Mestha

Haven't had this question for a while.

The reason there is the discrepancy is because ESM does not show you the true size of the mailbox. It only shows you part of the size.

"When you view the space that a mailbox uses in Exchange System Manager, the amount only includes the space that is used by the Priv.edb file. The amount does not include the space that the Priv.stm file uses. "

Source: http://support.microsoft.com/kb/828070/

Therefore it is normal for the sum of the mailboxes not to equal the size of the database.

An offline defrag was a waste of time.

So to answer your question, you should be doing nothing, and have no concerns.

-M
ASKER
EnvisionTech

Thanks for all the answers but I'm still not clear:

ehabsalem:  there are no error 1211 in my application logs

rakeshmiglani: we have deleted item retention set to 2 days
 - I"m not exactly sure how single instance restore would factor in here, can you explain further?

Mestha:
- I've seen that before and maybe I'm misunderstanding, but this would mean that my situation is unusual.  When I look at the mailbox sizes in ESM they add up to about 8GB, and according to the quote above, this should reflect the size of the Priv.edb file.  However, my Priv.edb is 15GB on its own. The Priv.stm file is an additional 2.5GB.
   Am I misunderstanding something?



ASKER CERTIFIED SOLUTION
Mestha

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
EnvisionTech

Thanks for getting back to me Mestha.

So I checked the events you mentioned and after a sampling I see that its reporting anywhere from 10-50mb of free space.

I went back all the way to early 2008 and those seem to be pretty consistent all the way back.

Am I correct in understanding that the values in this event would represent how much space I would expect to gain with an offline defrag?  
This was kind of what got us down this road, after an offline defrag of the DB, we didn't really gain any space at all, so I thought there might be  a problem with exchange.

So as far as your experience goes, there is nothing to worry about if the priv file is double what is shown in ESM.  And not gaining any space from an offline defrag is because we didn't really have any white space as indicated by the 1221 events?

We have already changed the max allowable exchange size to prevent it from going offline at 16GB.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Mestha

If you are only seeing 10 - 50mb in event ID 1221 then an offline defrag is a waste of time. That is the maximum space you would gain.
So a total store size that is double what you see when you add up the list of mailboxes, while a little high, wouldn't be unusual.

-M
ASKER
EnvisionTech

Thanks for your help!