Forum Discussion
VirgilDobos
Moderator
Hi mate,
Try this SQL query. It will give you both compressed and uncompressed (original) size of the data.
SELECT SUM(S.ItemSize)/1024 "Compressed Size (MB)",
SUM(SP.OriginalSize)/1024/1024 "Uncompressed Size (MB)"
FROM VaultStoreDB.dbo.Saveset S,
VaultStoreDB.dbo.SavesetProperty SP
WHERE S.SavesetIdentity = SP.SavesetIdentity
Just replace the VaultStoreDB with the Vault Store Database name.
Slack
7 years agoLevel 4
Hi Virgil,
Same info as above. Gives a total size compressed and uncompressed - does this cater for Single Instance Storage?
Thanks - James
- patrickkuah7 years agoLevel 6
Hi,
Nope. thre query does not cater for single instancing. There is another EV report SIS ratio, you may use the ratio for your calculation though....
patrickkuah
Related Content
- 3 months ago
- 11 years ago
- 12 years ago