EV - performance stats, how long between an email arriving in journal mailbox to being discoverable in EV?

[goatboy]

Hi

EV 9.0.2

I'm trying to get some stats around how long it takes between an email arriving in journal mailbox to being discoverable in EV.

I can pull archiving rates via SQL, and indexing rates via Log Parser.

But I can't think of a good way to automate an large end to end test, besides manually emailing the journal mailbox, then searching in EV to see if the message has been indexed and therefore is discoverable. I am not sure if this is even possible given that EV does not know if there is a big backlog of messages it needs to process in the journal mailbox.

Any suggestions? Thanks!

[JesusWept3 · Accepted solution]

EV does have counters for items in the journal mailbox
If you do a Perfmon you will see counters for total items in the mailbox, total pending, total failed etc
Items that are awaiting to be indexed will be placed in the JournalArchive table in the VaultStore database with IndexCommited = 0

So you can do a COUNT(*) FROM JournalArchive WHERE IndexCommited = 0
This will show you the amount of items that are awaiting to be indexed

Juding how long it takes to index an item you can judge via a DTrace of Indexes.
So in your case you would DTrace IndexServer and then you get some deltas.
Typically it takes about half a second to archive an item.

When you email something that gets journaled by Exchange 2007 or 2010, the item will come in to the mailbox, EV will then change it to a part pending item and keep it for 5 minutes to make sure no new journal reports come in, then after 5 minutes its sent to storage.....then after its archived the item gets removed from the journal mailbox

So big items can take up to 3s to process (Depending on size and complexity of the message)
Most take about half a second.

So you could send a message with a unique ID to yourself, it then hits the journal mailbox
You should then be able to search for that message in maybe 5 minutes 5 seconds

But again, it all depends on current backlog in journaling, indexing, speed of network, load of EV Server etc etc