Forum Discussion

Trafford's avatar
Trafford
Level 4
13 years ago
Solved

Estimating size for FSA Reporting Database

Is there a guideline for sizing FSA reporting databases for EV 9 and / or 10?

ie an indication of how much data per file scanned is stored in the data base, or conversely database size per million files scanned, or such like.

None of the Installation, Admin, Planning, Reporting, or Performance guides seem to have any indication.

I found the rather dated (2010)  Technote TECH70262 - Sizing guidelines for Enterprise Vault databases (EV8), which gives the default initial sizes, of the dbs, and then the rather unhelpful statement :-

"Ensure that there is adequate space for the database to grow as monitoring data is added."

That's exactly what I am trying to do, but I cannot find any info from which to make any kind of calculation as to what "Adequate" might be.

Perhaps someone with a running FSA reporting DB can make a rough calculation.

Thanks

 

Best Practice
Enterprise Vault
Information Governance
Installing
Performance
Reporting
Tip-How to
  • RahulG's avatar
    RahulG
    13 years ago

    refer the following technote 

    http://www.symantec.com/business/support/index?page=content&id=TECH70262

    refer http://www.google.co.in/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&cad=rja&ved=0CB8QFjAA&url=http%3A%2F%2Fwww.symantec.com%2Fbusiness%2Fsupport%2Fresources%2Fsites%2FBUSINESS%2Fcontent%2Flive%2FDOCUMENTATION%2F5000%2FDOC5365%2Fen_US%2FEV10_SQL_Best_Practices_Guide.pdf&ei=q3yOUMnrGObxygHGg4Fo&usg=AFQjCNHkG9maPEkwJba14U5_q8Aml6N9Eg&sig2=O4TeofA0HsVm2eWFdf46HQ

3 Replies

Sort By
  • RahulG's avatar
    RahulG
    Level 6
    13 years ago

    refer the following technote 

    http://www.symantec.com/business/support/index?page=content&id=TECH70262

    refer http://www.google.co.in/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&cad=rja&ved=0CB8QFjAA&url=http%3A%2F%2Fwww.symantec.com%2Fbusiness%2Fsupport%2Fresources%2Fsites%2FBUSINESS%2Fcontent%2Flive%2FDOCUMENTATION%2F5000%2FDOC5365%2Fen_US%2FEV10_SQL_Best_Practices_Guide.pdf&ei=q3yOUMnrGObxygHGg4Fo&usg=AFQjCNHkG9maPEkwJba14U5_q8Aml6N9Eg&sig2=O4TeofA0HsVm2eWFdf46HQ

  • JesusWept3's avatar
    JesusWept3
    Level 6
    13 years ago

    So based on the SQL Best Practices that Rahul posted, its on page 23 and has the following

    Estimated (MB) = ((4.248f)+(0.339fv)+(2.218fr)+(0.536tr)+(0.61fvur)+(0.11fvr))/1000

     

    s

    Total number of file servers

    u

    Average number of users per file server

    v

    Average volumes per file server

    t

    Total number of unique file types

    r

    Historical retention period (days – recommended 30)

     

    Unfortunately, the documentations a little messed up, it says S = file servers, but i think it must mean F
    Also MB should be /1024, not /1000

    But basically
    F/S = 100 (File Servers)
    U = 1000 (avg users per server)
    V = 5 (volumes per server)
    T = 60 (unique file types)
    R = 30 (Data Retention)

    That would be 8.73GB according to that calculation

     

  • Trafford's avatar
    Trafford
    Level 4
    13 years ago

    Thanks Guys, exactly what I was looking for.

    as I mentioned I did find Tech70262, but it wasnt terribly helpful.

    I spent a good couple of hours searching around FSA Size database etc, I am suprised it didn't turn up the excellent SQL sizing guide, possibly because I often included EV9.

    You know it never ceases to amaze me that this kind of info isn't included in the documentation. This sizing is absolutely fundamental to implementing a product like EV.

    It is ludicrous that one should have to go scratching around for it.

    To supplement RahulG's Google link to the document, here is the link to DOC5365,

    "Symantec Enterprise Vault 10.0: SQL Best Practices Guide" 

    in the Symantec Knowledgebase

    http://www.symantec.com/business/support/index?page=content&id=DOC5365&actp=search&viewlocale=en_US&searchid=1351575211828