Forum Discussion

Corry's avatar
12 years ago

Future Storage Capacity Requirements

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

 

 

 

 

 

 

  • 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

1 Reply

  • 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