cancel
Showing results for 
Search instead for 
Did you mean: 

Future Storage Capacity Requirements

Corry
Not applicable

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

 

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

TonySterling
Moderator
Moderator
Partner    VIP    Accredited Certified

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

View solution in original post

1 REPLY 1

TonySterling
Moderator
Moderator
Partner    VIP    Accredited Certified

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