+3
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
View originalI will need to check with the developers on this and get back to you.
Reqards,
Edward J Holowienka
+3
hi
The developers are wanting to know what report are you looking at.
Regards,
Edward J Holowienka
+3
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.
I have passed the information onto the developers, as soon as I hear from them I will update the thread.
Reqards,
Edward J Holowienka
+3
may i have any updates from development team please?
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
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
