Exchange 2003 SP2 Database Improvements

I guess most people would state that the main new features of Exchange 2003 SP2 are the improvements to mobility services, although the increase in database storage size up to 75GB has certainly grabbed most people’s attention.  There are many other things to know regarding the database improvements within Exchange 2003 SP2 so I decided to have a closer look.

Goodbye 16GB
As I’m sure you are all aware, prior to Exchange 2003 SP2, the maximum permitted size of a single database on the Standard Edition of Exchange was 16GB.  Furthermore, I’m sure you are all aware that Exchange 2003 SP2 brings with it the ability for the Standard Edition to have databases up to 75GB.  Now that’s twice I’ve written ‘up to 75GB’.  Why?  Well, if you apply Exchange 2003 SP2 to your Standard Edition server, the database size limit is initially increased to 18GB.  Whilst you can go on to change this figure to a value up to 75GB, it’s important to note that 18GB is the default setting.

Controlling the size of the database is set via the registry.  For all the registry settings that I detail below that relate to making changes on a mailbox store, note that we’ll be working in the following registry key:

HKLM\System\CurrentControlSet\Services\MSExchangeIS\{server name}\Private-{GUID}

It therefore follows that for registry settings that relate to making changes on a public store, you’ll need to work in the following registry key:

HKLM\System\CurrentControlSet\Services\MSExchangeIS\{server name}\Public-{GUID}

Obviously in both cases {servername} means the name of your server and {GUID} is, well, the Globally Unique Identifier (GUID) of either the mailbox or public stores.  For example, in Figure 1 below, you can see that my server DCEXCH1 has three mailbox stores and a public folder store.  Obviously this is an Enterprise Edition server since there is more than one mailbox store.  Therefore, any registry changes you make will only affect that specific store.

Issp2fig1_2

Figure 1 – Mailbox & Public Store Registry Samples

Now back to controlling the size of a database.  Under the relevant database, create the following registry information:

Value type: REG_DWORD
Value name: Database Size Limit in GB

Set the value data to be the maximum size in gigabytes that the database is allowed to grow to.  For the Standard Edition of Exchange, you can enter numbers between 1 and 75.  For the Enterprise Edition, you can enter numbers between 1 and 8000.  Yes, that’s right, between 1GB and 8000GB or 8TB.  Therefore, even if you are running the Enterprise Edition of Exchange, you can still enforce overall database size limits of, say, 150GB if you so desire.

Let’s assume I set the first mailbox store with a 25GB limit.  To get this mailbox store to recognize the change, you simply need to dismount and remount the store.  When you do this, you’ll see event ID 1216 logged informing you of this fact.  For example, Figure 2 below shows the resulting information.  We will talk about physical database sizes and logical free space later on.  Additionally, it’s interesting to note that you will get event 1216 logged on an Enterprise Edition server for any database that has had a size limit configured.  Previously, all databases on an Enterprise Edition server would have been unlimited and therefore logged the event ID 1217.

Issp2fig2_1

Figure 2 – Event 1216 Showing Mailbox Store Limited to 25GB

Why 18GB?
So we’ve said that the default database size for the Standard Edition is 18GB.  Like me, you’ve probably wondered where this 18GB figure came from.  Well, to fully understand this, you have to understand something called the Database Size Buffer.  This is essentially a setting that informs Exchange to log an event in the Application event log if a database nears its maximum size.  However, how near is near?  The answer to that is 10% by default.  Now we can understand the thinking behind the 18GB default limit, since 10% of 18GB is approximately 2GB, which therefore means that the warning event log entry will be logged at about 16GB, the old Standard Edition limit.

Controlling the database size buffer is also achieved via the registry.  In the same manner as previously described above, create the following registry information under the relevant database:

Value type: REG_DWORD
Value name: Database Size Buffer in Percentage

Set the value data to be the desired percentage.  Therefore, if you enter 20 here, you’ll receive the warning event log entry when your database has 20% capacity left before it hits the maximum permitted size.  What event log entry is actually logged?  Well, it’s event ID 9688 as shown below in Figure 3.  In this example, I set a database size limit of 1GB and waited until the database grew to within the specified percentage.

Issp2fig3_1

Figure 3 – Event ID 9688 Warning of Database Size

Physical vs. Logical
As I mentioned earlier, we need to take a look at what is meant by the terms physical and logical as they relate to these event logs.  It’s simple really; the physical size of the database refers to the size of the EDB and STM files added together as seen in Explorer.  The logical size of the database is the physical size of the database minus any whitespace.  As I’m sure you all know, whitespace is the term used to describe the areas of the database that are not currently in use and will be re-used before the size of the database is expanded.  The amount of whitespace within a database can be determined by looking for event ID 1221 in the Application event log.

You will see from Figure 2 above that Exchange now calculates the size limit restrictions based on the logical space within a database.  For example, imagine I set my maximum permitted database size to 25GB and my database is now showing in Explorer as being 25GB in size.  However, if I have 2GB of whitespace within the database, my database will not currently hit the size limit since its effective logical size is 23GB.  This is good news.

By default, these limit checks are performed daily at 5am but you can change this via the registry by creating the following information under your chosen database as before:

Value type: REG_DWORD
Value name: Database Size Check Start Time in Hours From Midnight

Set the value data to be the number of hours past midnight to elapse before the size check takes place.  For example, if you want the checks to take place at 6pm (18:00) each day, you’d enter 18 here.

A Helping Hand
In the days before Exchange 2003 SP2, a Standard Edition database that exceeded the 16GB size limit would be dismounted.  Of course, there were several little tricks that you could play, like temporarily increasing the store size to 17GB via a registry tweak.  However, you now have a helping hand in Exchange 2003 SP2.  Now, when the specified database size limit is reached and the first database size check has been performed by Exchange (remember, this is once every 24 hours at 5am by default, unless you’ve used the registry change above) the database is NOT dismounted.  Instead, event ID 9689 will be logged as shown below in Figure 4.

Issp2fig4_1

Figure 4 – Event ID 9689 Showing Database Size Exceeded

You then have 24 hours to rectify the problem, otherwise, when the next database check is performed 24 hours later, the database will be dismounted and event ID 9690 will be logged as shown below in Figure 5.

Issp2fig5_1

Figure 5 – Event ID 9690 Showing Database Dismounted

But wait!  You can still mount the stores again even after event ID 9690 has been logged.  Unfortunately, it will be dismounted again after the next database size check is performed 24 hours later but at least you now have time to rectify the problem.  Despite this, I’m sure you’ll agree that Microsoft has made life much easier for Exchange administrators. 

Account Deleted on November 9, 2005 at 08:42 AM in Useful Info
« Outlook 2003 Junk E-mail Filter update: November 2005 | Main | Exchange 12 to be Exclusively 64 bit »

TrackBack

TrackBack URL for this entry:
http://www.typepad.com/services/trackback/6a00d8345191a569e200e5501fb3b38833

Listed below are links to weblogs that reference Exchange 2003 SP2 Database Improvements:

» Weekend reading from subject: exchange
[Read More]

Tracked on Nov 11, 2005 10:40:50 AM

» Good article about database changes in Exchange 2003 SP2 from baeke.info
The article on the MS Exchange Blog clearly explains the changes such as the database limits, logical vs. physical size ... [Read More]

Tracked on Nov 25, 2005 2:30:15 AM

Comments

Many thanks. Just what we needed.

Posted by: Steve Douglas at Nov 21, 2005 3:08:08 AM

Fantastic explanation, thank you.

Posted by: Latz at Dec 8, 2005 6:42:18 AM

Many thanks, it helped me save hours today when my exchange database dismounted
After reading the article i made the change in registry and now it looks good
thanks again
Cheers
Ehtisham

Posted by: Ehtisham at Oct 18, 2007 8:49:55 PM