WinSPC Knowledgebase Home | Glossary | Favorites | Contact | Login WinSPC Knowledgebase Home | Glossary | Favorites | Contact | Login
Search the WinSPC Knowledgebase Browse by Category

[Advanced Search]
How can I estimate the database storage requirements for WinSPC?
Article Details

Last Updated
5th of March, 2018

Applies to
WinSPC 7.2, WinSPC 8.0
Would you like to...
Print this page Print this page
Email this page Email this page
Post a comment Post a comment
Subscribe me
Add to favorites Add to favorites
Remove Highlighting Remove Highlighting
Edit this Article Edit this Article
Edit this Article Quick Edit
Export to PDF
To estimate the database storage requirements for your WinSPC database:
  1. Multiply your average subgroup size by 51. (E.g. 5x51=255)
  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. 255+1.32+69.6=325.92)
  5. Add 181.88 to the sum from step 4. (E.g. 181.88+325.92=507.80)
  6. Multiply the sum from step 5 by the average number of subgroups you collect per day. (E.g. 507.80x10,000=5,078,000)
  7. Divide the product from step 6 by 1,000,000. (E.g. 5,078,000/1,000,000=5.078.)
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 ©2010-2021 DataNet Quality Systems. All Rights Reserved.