06-27-2011 03:01 PM
I'm running a query on the EV SQL to collect the size of items in the archived. I'm getting a result (say 2000GB) which is different from the size reported by EV reporting (say 3400 GB). Any idea why this is? and is the size reported by my query accurate?
Please help.
Ravi
Solved! Go to Solution.
06-28-2011 06:07 AM
As far as I remember the usage.asp report is with compression but without single instance storage.
So it's the compressed size but not taking into account SIS.
So it's not entirely accurate depending on the amount of SIS.
I believe the SSRS reports take SIS into account (at least the SIS reports).
06-27-2011 03:32 PM
06-27-2011 03:37 PM
I'm using a script that queries the size of the archived items. im using the usage reports to get the data from the EV. The result of both seem to be different. Is it possible that the script i'm running is reporting a compressed size of the items instead of the original size?
06-27-2011 04:28 PM
can you post the script you are using?
06-28-2011 02:52 AM
Try this for uncompressed Vault Store Size:
SELECT COUNT(*) AS 'Number of Items', MIN(ArchivedDate) as 'Date From', MAX (ArchivedDate) AS 'Date to', SUM(ItemSize)/1024 AS 'Saveset Size (MB)', SUM(OriginalSize)/1024/1024 AS 'Orignal Size (MB)'
FROM Saveset INNER JOIN SavesetProperty ON Saveset.SavesetIdentity = SavesetProperty.SavesetIdentity WHERE ArchivedDate >'2018-03-04 22:00'
AND ArchivedDate < '1999-03-05 6:00'
If you have many databases to query you can use the USE command in SQL to specify each of the databases
USE database 2
SELECT COUNT(*) AS 'Number of Items', MIN(ArchivedDate) as 'Date From', MAX (ArchivedDate) AS 'Date to', SUM(ItemSize)/1024 AS 'Saveset Size (MB)', SUM(OriginalSize)/1024/1024 AS 'Orignal Size (MB)'
FROM Saveset INNER JOIN SavesetProperty ON Saveset.SavesetIdentity = SavesetProperty.SavesetIdentity WHERE ArchivedDate >'2018-03-04 22:00'
AND ArchivedDate < '1999-03-05 6:00'
UNION
USE database 2
SELECT COUNT(*) AS 'Number of Items', MIN(ArchivedDate) as 'Date From', MAX (ArchivedDate) AS 'Date to', SUM(ItemSize)/1024 AS 'Saveset Size (MB)', SUM(OriginalSize)/1024/1024 AS 'Orignal Size (MB)'
FROM Saveset INNER JOIN SavesetProperty ON Saveset.SavesetIdentity = SavesetProperty.SavesetIdentity WHERE ArchivedDate >'2018-03-04 22:00'
AND ArchivedDate < '1999-03-05 6:00'
06-28-2011 06:07 AM
As far as I remember the usage.asp report is with compression but without single instance storage.
So it's the compressed size but not taking into account SIS.
So it's not entirely accurate depending on the amount of SIS.
I believe the SSRS reports take SIS into account (at least the SIS reports).