Enterprise Vault Compression Ratio

[JMCBH]

I need to confirm the following and need a pointer in the right direction:

Confirm the total email storage capacity currently stored in the Enterprise Vault deployment and confirm the compression ration on the archive. 

[GertjanA]

If you search in the forum on 'archive size sql' you will find several scripts.

I use the below: Replace YourVaultStoreDatabase with the name of your VaultStoreDatabase

SELECT A.ArchiveName,
       COUNT(S.IdTransaction) "Num. Items Archived",
       SUM(S.ItemSize)/1024 "Archived Items Size (MB)",
       SUM(SP.OriginalSize)/1024/1024 "Original Email Size (MB)"
FROM   EnterpriseVaultDirectory.dbo.Archive A,
       EnterpriseVaultDirectory.dbo.Root R,
YourVaultStoreDatabase.dbo.ArchivePoint AP,
YourVaultStoreDatabase.dbo.Saveset S,
YourVaultStoreDatabase.dbo.SavesetProperty SP
WHERE  S.SavesetIdentity = SP.SavesetIdentity
  AND  S.ArchivePointIdentity = AP.ArchivePointIdentity
  AND  AP.ArchivePointId = R.VaultEntryId
  AND  R.RootIdentity = A.RootIdentity
GROUP BY A.ArchiveName

Also if you have EV reporting ( on a SQL reporting server), there are SIS reports.

[JMCBH]

Gertjan
 

Do I run this as an SQL query against the vault store database?

[JesusWept3 · Accepted solution]

You're not gonna really see much space savings from compression except for really big items, the user information and converted content will make it as big, if not bigger than most small items Real space savings comes from SIS You should use usage reports and sis reports for SQL Reporting

[JesusWept3]

Oh and the SQL query Gertjan posted goes across directory and vault store database, you will have to change yourVaultStore to the name of your vault store database

[JMCBH]

JesusWept3

we were asked the to confirm the following by third party:

Confirm the total email storage capacity currently stored in the Enterprise Vault deployment? i have checked the size of the vault store partitions folders on the SAN and they are 122GB and 60GB, however when running the report in the EV console vault store usage reporter it says total size of items 194MB.

 confirm the compression ration on the archive? would this script provide that answer.