07-26-2012 06:06 AM
Hello,
I am currenlty looking at finding an appropriate method of predicting future storage requirements for our EV enviroment. Is there aquick easy way to do this via a spreadsheet and inputting certain parameters ? or am I dreaming and is it a complex method.
Any advice is very welcome
Solved! Go to Solution.
07-26-2012 07:15 AM
Hello Corry,
There are partner tools for storage requirements but unless you are a partner you won't have access to them. You could reach out to a partner to get a Health Check and have the storage requirements be part of that.
If you do not want to engage a partner what you can do is look at your past usage and build a trend for the future.
You could use SQL queries to see your archive rate in the past and try to estimate that for the future.
--Daily Rate
select "Archived Date" = left (convert (varchar, archiveddate,20),10),"Daily Rate" = count (*),"Size" = sum (itemsize)
from saveset
where archiveddate > dateadd("dd", -30, getdate ())
group by left(convert (varchar, archiveddate,20),10)
order by "Archived Date" Desc
--Monthly Rate
select "Archived Date" = left (convert (varchar, archiveddate,20),7),"Monthly Rate" = count (*),"Size" = sum (itemsize)
from saveset
where archiveddate > dateadd("mm", -12, getdate ())
group by left(convert (varchar, archiveddate,20),7)
order by "Archived Date" Desc
--Yearly Rate
select "Archived Date" = left (convert (varchar, archiveddate,20),4),"Yearly Rate" = count (*),"Size" = sum (itemsize)
from saveset
where archiveddate > dateadd("YY", -3, getdate ())
group by left(convert (varchar, archiveddate,20),4)
order by "Archived Date" Desc
Regards,
Tony
07-26-2012 07:15 AM
Hello Corry,
There are partner tools for storage requirements but unless you are a partner you won't have access to them. You could reach out to a partner to get a Health Check and have the storage requirements be part of that.
If you do not want to engage a partner what you can do is look at your past usage and build a trend for the future.
You could use SQL queries to see your archive rate in the past and try to estimate that for the future.
--Daily Rate
select "Archived Date" = left (convert (varchar, archiveddate,20),10),"Daily Rate" = count (*),"Size" = sum (itemsize)
from saveset
where archiveddate > dateadd("dd", -30, getdate ())
group by left(convert (varchar, archiveddate,20),10)
order by "Archived Date" Desc
--Monthly Rate
select "Archived Date" = left (convert (varchar, archiveddate,20),7),"Monthly Rate" = count (*),"Size" = sum (itemsize)
from saveset
where archiveddate > dateadd("mm", -12, getdate ())
group by left(convert (varchar, archiveddate,20),7)
order by "Archived Date" Desc
--Yearly Rate
select "Archived Date" = left (convert (varchar, archiveddate,20),4),"Yearly Rate" = count (*),"Size" = sum (itemsize)
from saveset
where archiveddate > dateadd("YY", -3, getdate ())
group by left(convert (varchar, archiveddate,20),4)
order by "Archived Date" Desc
Regards,
Tony