WinSPC Knowledgebase Home | Glossary | Favorites | Contact | Login WinSPC Knowledgebase Home | Glossary | Favorites | Contact | Login
Search the WinSPC Knowledgebase Browse by Category
How can I estimate the database storage requirements for WinSPC?
Article Details

Last Updated
7th of March, 2012

Applies to
WinSPC 7.2, WinSPC 8.0

To estimate the database storage requirements for your WinSPC database:
  1. Multiply your average subgroup size by 37. (E.g. 5x37=185)
  2. Multiply your average percentage of subgroups in violation by 66.  (E.g. 2%x66=1.32)
  3. Multiply your average number of tag values per subgroup by 17.4. (E.g. 4x17.4=69.6)
  4. Add the results from the above three steps together. (E.g. 185+1.32+69.6=255.92)
  5. Add 141.88 to the sum from step 4. (E.g. 141.88+255.92=397.80)
  6. Multiply the sum from step 5 by the average number of subgroups you collect per day. (E.g. 397.80x10,000=3,978,000)
  7. Divide the product from step 6 by 1,000,000. (E.g. 3,978,000/1,000,000=3.978.)
The answer you get from step 7 is the MB of disk space you can expect to be consumed per day of WinSPC operation. 
Attachments
No attachments were found.
Related Articles
Visitor Comments
No visitor comments posted. Post a comment
Post Comment for "How can I estimate the database storage requirements for WinSPC?"
To post a comment for this article, simply complete the form below. Fields marked with an asterisk are required.
   Your Name:
   Email Address:
* Your Comment:
* Enter the code below:
 

All Content 2012 DataNet Quality Systems. All Rights Reserved.