Oracle I/O Throughput vs Media Agent I/O Throughput

Last post 12-07-2018, 10:29 AM by efg. 3 replies.
Sort Posts: Previous Next
  • Oracle I/O Throughput vs Media Agent I/O Throughput
    Posted: 12-06-2018, 8:43 AM

    Hi. I am hoping someone can help med with explaining the following regarding ORASBT IO Statistics...

    Oracle I/O Throughput and Media Agent I/O Throughput

     

    Please correct me if I am wrong but Oracle I/O Throughput, is the io throughput on the Database/Server/Subclient, and Media Agent I/O Throughput is the io throughput to the Commserver(Mediaservers).

    If I have high throughput on Oracle I/O, but Media Agent I/O Throughput seem to be capped at a lower number - where and what should I in general be looking at ?

    We have managed to increase the Oracle I/O Throughput, but unable to increase the Media Agent I/O Throughput.

     

    Best regards

    Martin

     

  • Re: Oracle I/O Throughput vs Media Agent I/O Throughput
    Posted: 12-06-2018, 5:12 PM
    • efg is not online. Last active: 12-10-2018, 10:05 AM efg
    • Top 10 Contributor
    • Joined on 02-02-2010
    • CommVault Tinton Falls NJ
    • Expert
    • Points 1,580

    Hi Martin,

    It's been a while since I looked at MA performance, but in a nutshell, you will want to look at the network performance between the MA and Oracle servers as well as the disk performance on the MA.  There are utilities installed in Commvault that can help with this.  Look for CvNetworkTestTool as well as CVDiskPerf in the Base folder where commvault is installed on the MA.  Here are some links in the documentation that covers these utilities:

    CommCell Performance Tuning

    Network Performance Test Tool

    Disk Performance Tool

    Let us know if this helps...


    Ernst F. Graeler
    Product Specialist
    Applications and File Systems
  • Re: Oracle I/O Throughput vs Media Agent I/O Throughput
    Posted: 12-07-2018, 3:45 AM

    Hi Ernst. Thank you for your response. These Tools (Disk perf and Network perf) needs to be run on the Commserver right ? Not the SubClient/Client Server.

    If you look at the below numbers. First one is a backup frome one server. The second is a restore of that backup on a different server. What is your immediate opinon ?

     

    Backup: (3 out of 8 streams displayed)

    1037 40d 12/06 14:08:14 3156680 sbtclose2: SBTPS: Stream no = 1, Archive File Name = 3156680_BOSKONV_p3tk3i6s_1_1, Size = 201070739456 bytes, Oracle I/O Time = 109.335923 secs,  MA I/O Time = 2176.623941 secs, Total (Oracle + MA) I/O Time = 2285.959864 secs
    1037 40d 12/06 14:08:14 3156680 sbtclose2: SBTPS: Stream no = 1, Archive File Name = 3156680_BOSKONV_p3tk3i6s_1_1, Oracle I/O Throughput = 6165.788599 GB/Hr, MA I/O Throughput = 309.719182 GB/Hr, Total I/O Throughput = 294.905522 GB/Hr

    1039 40f 12/06 14:08:09 3156680 sbtclose2: SBTPS: Stream no = 2, Archive File Name = 3156680_BOSKONV_p4tk3i6s_1_1, Size = 200141701120 bytes, Oracle I/O Time = 108.808611 secs, MA I/O Time = 2170.564039 secs, Total (Oracle + MA) I/O Time = 2279.372650 secs
    1039 40f 12/06 14:08:09 3156680 sbtclose2: SBTPS: Stream no = 2, Archive File Name = 3156680_BOSKONV_p4tk3i6s_1_1, Oracle I/O Throughput = 6167.042641 GB/Hr, MA I/O Throughput = 309.148835 GB/Hr, Total I/O Throughput = 294.391241 GB/Hrq

    1041 411 12/06 14:07:49 3156680 sbtclose2: SBTPS: Stream no = 3, Archive File Name = 3156680_BOSKONV_p5tk3i6s_1_1, Size = 198985121792 bytes, Oracle I/O Time = 107.936281 secs, MA I/O Time = 2154.010396 secs, Total (Oracle + MA) I/O Time = 2261.946677 secs
    1041 411 12/06 14:07:49 3156680 sbtclose2: SBTPS: Stream no = 3, Archive File Name = 3156680_BOSKONV_p5tk3i6s_1_1, Oracle I/O Throughput = 6180.957906 GB/Hr, MA I/O Throughput = 309.724415 GB/Hr, Total I/O Throughput = 294.944888 GB/Hr
     
    Restore: (3 out of 8 streams displayed)
    23968 5da0 12/05 20:25:58 3150480 sbtend: SBTPS: Stream no = 1, Number of Archive files processed = 22 ,Total bytes transferred during the API session = 32500613120, Total Oracle I/O Time = 57.087747 secs, Total MA I/O Time = 327.850344 secs, Total (Oracle + MA) I/O Time = 384.938091
    23968 5da0 12/05 20:25:58 3150480 sbtend: SBTPS: Stream no = 1, Oracle I/O Throughput = 1908.759806 GB/Hr, Media Agent I/O Throughput = 332.367493 GB/Hr, Total I/O Throughput = 283.076161 GB/Hr

    23970 5da2 12/05 20:26:04 3150480 sbtend: SBTPS: Stream no = 2, Number of Archive files processed = 14 ,Total bytes transferred during the API session = 29765926912, Total Oracle I/O Time = 75.029359 secs, Total MA I/O Time = 327.035317 secs, Total (Oracle + MA) I/O Time = 402.064676
    23970 5da2 12/05 20:26:04 3150480 sbtend: SBTPS: Stream no = 2, Oracle I/O Throughput = 1330.119945 GB/Hr, Media Agent I/O Throughput = 305.159846 GB/Hr, Total I/O Throughput = 248.213914 GB/Hr

    23972 5da4 12/05 20:26:10 3150480 sbtend: SBTPS: Stream no = 3, Number of Archive files processed = 18 ,Total bytes transferred during the API session = 25033703424, Total Oracle I/O Time = 67.789460 secs, Total MA I/O Time = 264.179552 secs, Total (Oracle + MA) I/O Time = 331.969012
    23972 5da4 12/05 20:26:10 3150480 sbtend: SBTPS: Stream no = 3, Oracle I/O Throughput = 1238.128040 GB/Hr, Media Agent I/O Throughput = 317.708281 GB/Hr, Total I/O Throughput = 252.830922 GB/Hr
     
    Thanks again
    /Martin
  • Re: Oracle I/O Throughput vs Media Agent I/O Throughput
    Posted: 12-07-2018, 10:29 AM
    • efg is not online. Last active: 12-10-2018, 10:05 AM efg
    • Top 10 Contributor
    • Joined on 02-02-2010
    • CommVault Tinton Falls NJ
    • Expert
    • Points 1,580

    Hi Martin,

    The bottleneck looks like it could be the media agent.  Based on the 3 streams you are averaging just over 300GB/hr per stream.  So with a total of 8 streams that comes to about 2.4 TB/hr throughput for the over all process.  The utilities I mentioned in my prior post should be run on the Media Agent (for CvDiskPerf) with focus on the disk library location (where the media/data is being written to).  As far as the CvNetworkTestTool...  that should be run between the MediaAgent being used for the backup/restore and the client being backed up from or restored to.  That will verify/validate what the expected throughput would be as far as how fast the MA can write to the disk storage, as well as how fast the MA/Client can transfer data between each other.  Remember that the lower transfer rate (network vs disk) would be the what can be expected for the total transfer rate of the over all backup or restore process as you can only move data as fast as the slowest component in the over all process.

    The documentation should be able to guide you through usage and application of these utilities.  The Support folks are also quite familiar with these utilities, and can provide additional guidance if you have any problems, so please don't hesitate to reach out to them as well.


    Ernst F. Graeler
    Product Specialist
    Applications and File Systems
The content of the forums, threads and posts reflects the thoughts and opinions of each author, and does not represent the thoughts, opinions, plans or strategies of Commvault Systems, Inc. ("Commvault") and Commvault undertakes no obligation to update, correct or modify any statements made in this forum. Any and all third party links, statements, comments, or feedback posted to, or otherwise provided by this forum, thread or post are not affiliated with, nor endorsed by, Commvault.
Commvault, Commvault and logo, the “CV” logo, Commvault Systems, Solving Forward, SIM, Singular Information Management, Simpana, Commvault Galaxy, Unified Data Management, QiNetix, Quick Recovery, QR, CommNet, GridStor, Vault Tracker, InnerVault, QuickSnap, QSnap, Recovery Director, CommServe, CommCell, SnapProtect, ROMS, and CommValue, are trademarks or registered trademarks of Commvault Systems, Inc. All other third party brands, products, service names, trademarks, or registered service marks are the property of and used to identify the products or services of their respective owners. All specifications are subject to change without notice.
Close
Copyright © 2018 Commvault | All Rights Reserved. | Legal | Privacy Policy