Skip to main content
Solved

Description of columns for cf_SurveyLibraryThroughput table under CVCloud Database


Forum|alt.badge.img+4

Where do we get Description of columns for cf_SurveyLibraryThroughput table under CVCloud Database.

What is the formula to get avg throughput per day from these parameters in the table[cf_SurveyLibraryThroughput ]?

 

Best answer by HolowEd

@ManojR,

The developers have gotten back to me on this, here is the formula used for the calculation

                The formula for calculating throughput is :
                               
                                3600*(DataReadMB+DataWrittenMB)/1024*UsedSeconds [GB/hr].

                                where DataReadMB, DataWrittenMB and UsedSeconds are values from the table cf_SurveyLibraryThroughput.

Regards,

Edward J Holowienka

View original
Did this answer your question?

8 replies

Forum|alt.badge.img+12
  • Vaulter
  • 173 replies
  • March 13, 2024

@ManojR,

I will need to check with the developers on this and get back to you.

Reqards,

Edward J Holowienka


Forum|alt.badge.img+4
  • Author
  • Byte
  • 12 replies
  • March 15, 2024

hi @HolowEd : any update from development team?


Forum|alt.badge.img+12
  • Vaulter
  • 173 replies
  • March 15, 2024

@ManojR,

 

The developers are wanting to know what report are you looking at.

Regards,

Edward J Holowienka


Forum|alt.badge.img+4
  • Author
  • Byte
  • 12 replies
  • March 18, 2024

I’m looking for a Library & Tape Drive level [read & write]throughput trend for a period of last SIX months.

I can see the history under this table for Library read, write data along with used seconds [ cf_SurveyLibraryThroughput ] but how can we calculate throughput by read, write data & used seconds ?

 

I’ve referred Average throughput report for last 7 days but it doesn’t suffice my requirement mentioned above. Hence, If you have any other report/table/Logic to calculate from table [ cf_SurveyLibraryThroughput ] …. would be really helpful.
 


Forum|alt.badge.img+12
  • Vaulter
  • 173 replies
  • March 18, 2024

@ManojR,

I have passed the information onto the developers, as soon as I hear from them I will update the thread.

Reqards,

Edward J Holowienka


Forum|alt.badge.img+4
  • Author
  • Byte
  • 12 replies
  • March 21, 2024

may i have any updates from development team please?


Forum|alt.badge.img+12
  • Vaulter
  • 173 replies
  • March 21, 2024

@ManojR,

 

The developers haven’t gotten back to me yet. I have asked for an update from them. As soon as they respond I will update you.

Regards,

Edward J Holowienka


Forum|alt.badge.img+12
  • Vaulter
  • 173 replies
  • Answer
  • March 22, 2024

@ManojR,

The developers have gotten back to me on this, here is the formula used for the calculation

                The formula for calculating throughput is :
                               
                                3600*(DataReadMB+DataWrittenMB)/1024*UsedSeconds [GB/hr].

                                where DataReadMB, DataWrittenMB and UsedSeconds are values from the table cf_SurveyLibraryThroughput.

Regards,

Edward J Holowienka


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings