Solved

Exchange and transaction logs

Posted on 2011-09-10
2
226 Views
Last Modified: 2012-05-12
Hello

My understanding is that Exchange will write information to transaction logs/memory first as an action takes place and then write this information to the database when it has some spare time. For instance, UserA deletes an item in their inbox. Exchange first writes this change to the current transaction log/memory, then when it is less busy, it will write this change to the ESE database itself. Also, usually, Exchange will use the data in memory to write to the database, as opposed to the transaction logs. The logs are actually used only if the server crashes and the memory is no longer there. If the transaction log itself is corrupt/not present, this will be a problem because the ESE db will be out of sync.

Do I have the basic idea correct?

My question is - how long does ESE usually lag behind transaction logs/memory? Are we talking about a few mins, an hour, a day etc?

And, for a database that is mounted, is is possible to tell (using an ESEutil command, for example) what the last log file that was commited was?

Applies to Exchange 2007 and 2010.
0
Comment
Question by:neil4933
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 27

Assisted Solution

by:davorin
davorin earned 200 total points
ID: 36516279
0
 
LVL 49

Accepted Solution

by:
Akhater earned 300 total points
ID: 36516835
I am not sure this is what you meant by what you wrote so sorry if I am just repeating you

The information store will try to reserve as much memory as possible since memory access is much faster than disk

every change is written simultaneously to the memory and to the transaction logs (this is called write-ahead logging).

then changes are committed from the memory to the database and updated in the checkpoint file.

So yes, in active copy of the database, logs are only used in a crash.

The lag is surely not hours not even minutes, I would say seconds but I don't think this is documented anywhere
and no there is no way of knowing, on a mounted database, which log files are now committed and which not
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

MS Outlook is a world-class email client application that is mainly used for e-communication globally.  In this article, we will discuss the basic idea about MS Outlook, its advanced features, and types of MS Outlook File formats.
A list of top three free exchange EDB viewers that helps the user to extract a mailbox from an unmounted .edb file and get a clear preview of all emails & other items with just a single click on mailboxes.
how to add IIS SMTP to handle application/Scanner relays into office 365.
This video discusses moving either the default database or any database to a new volume.
Suggested Courses

628 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question