scalereport_drive_usage_throughput_perdrive

Scope

Intended Audience
All X
CommVault Internal  
CE/System Test  
Development  

Platform

  • CommServer (Database: CommServ)

Release

  • 10.0.0

Description

Report Format:


---------------------------------------------------------------------------------------------


LibraryName, DriveName, DriveUsage_hr, DriveUsage_24hr, ThroughputGB_hr, ThroughputGB_24hr


---------------------------------------------------------------------------------------------


********************************** Drive Usage Per Hour ********************************


*


* The drive usage is given by the amount of time a drive is used for either


* writing or for reading purposes. These details can be obtained from the


* MMDriveHistory table. The time at which a write or a read operation has


* started is given by TimeStart column. Hence we can obtain the amount of time


* a drive is in use by summing up the DataWriteDurationSec+DataReadDurationSec


* grouping by the DriveId. Using the above sum we can find the percentage of


* time the drive is in use over one hour and twenty four hours duration.


*


****************************************************************************************


************************* Throughput of the Drive in GB/Hr *****************************


*


* The throughput of a drive is calculated based on the amount of data has been


* read or written to a drive in an hour. The columns DataWritten and DataRead in


* the same table as above gives the required data. This sum DataWritten+DataRead


* is again averaged for the last one hour and for twenty four hours.


*


****************************************************************************************


Usage

  • QOperation execscript -sn scalereport_drive_usage_throughput_perdrive.sql
     
  • Version

  • 1.2
     
  • Disclaimer of Warranties

    CommVault provides software tools and utilities on an "as is" basis, as a courtesy and convenience to its users, and they may be changed from time to time without notice. These tools and utilities are provided without express, implied, or statutory warranties of any kind. You assume full risk and responsibility for the selection, possession, performance and proper installation and use of the software tools and utilities, and for verifying the results obtained there from. Your use of CommVault software tools and utilities indicates your unconditional acceptance of the above disclaimer.