12-22-2010 02:08 AM
I need to find out how much is transfered/cross-archived during archiving. It's a scenario where the user archive is located on evserver1 but the mailbox exist on the exchange server archived by evserver2.
Thanks,
Fredrik
12-22-2010 02:59 AM
I guess the amount of data archived for the mailbox which is on the exchange server archived by EvServer 2 would be the same transfere/cross-archived .
You can run the report to find find out how much item archived per hour or day .
12-22-2010 04:30 AM
I was a bit unclear in my question, it's not just a question of one user/archive.
If possible I would like to monitor this in real time, e.g. via perfmon.
E.g. if there is a MSMQ queue that will show this type of communication.
12-22-2010 05:01 AM
Outgoing (MSM)queues should be created if Server 1 has the archive but Server 2 targets the Exchange
12-22-2010 07:13 AM
Well you hit it on the head really, just use Perfmon, EV and MSMQ both have their own Perfmon counters that you can use.... but I have a query that might be insightful to you
SELECT COUNT(DISTINCT(S.ArchivePointIdentity)) "# of Mailboxes Archived", COUNT(S.ItemSize) "# of Items Archived", SUM(S.ItemSize) "Size of Items Archived (KB)" FROM EnterpriseVaultDirectory.dbo.ExchangeMailboxEntry EME, EnterpriseVaultDirectory.dbo.ExchangeMailboxStore EMS, EnterpriseVaultDirectory.dbo.ExchangeServerEntry ESE, EnterpriseVaultDirectory.dbo.ArchivingRetrievalTask ART, EnterpriseVaultDirectory.dbo.Task T, EnterpriseVaultDirectory.dbo.Root R, EnterpriseVaultDirectory.dbo.Archive A, EnterpriseVaultDirectory.dbo.VaultStoreEntry VSE, EnterpriseVaultDirectory.dbo.StorageServiceEntry SSE, EnterpriseVaultDirectory.dbo.ComputerEntry CE, YourVaultStore.dbo.Saveset S, YourVaultStore.dbo.ArchivePoint AP WHERE EME.MbxStoreIdentity = EMS.MbxStoreIdentity AND EMS.ExchangeServerIdentity = ESE.ExchangeServerIdentity AND ESE.ExchangeServerEntryID = ART.ExchangeServerEntryID AND ART.TaskEntryId = T.TaskEntryID AND EME.DefaultVaultID = R.VaultEntryID AND R.RootIdentity = A.RootIdentity AND A.VaultStoreEntryID = VSE.VaultStoreEntryID AND VSE.StorageServiceEntryID = SSE.ServiceEntryID AND SSE.ComputerEntryID = CE.ComputerEntryID AND T.ComputerEntryID != SSE.ComputerEntryID AND S.ArchivePointIdentity = AP.ArchivePointIdentity AND AP.ArchivePointId = EME.DefaultVaultId AND S.ArchivedDate > '2010-12-01'
The above is an EV9 Query, to make it work in EV8 and below change the following
From
WHERE EME.MbxStoreIdentity = EMS.MbxStoreIdentity AND EMS.ExchangeServerIdentity = ESE.ExchangeServerIdentity
To
WHERE EME.ExchangeServerIdentity = ESE.ExchangeServerIdentity
And also remove the following line in the FROM Clause
EnterpriseVaultDirectory.dbo.ExchangeMailboxStore EMS,
Also don't forget to change YourVaultStore.dbo. to the Database name of your vault store. Also you can change the S.ArchivedDate to change the filter So for the last day you could do WHERE S.ArchivedDate > DATEADD(d, -1, GetDate())