1. Community Tip: Please Give Thanks to Those Sharing Their Knowledge.
    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.
  2. Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)
    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

Speed of Processes

Discussion in 'Scripting' started by johnsot, Dec 10, 2010.

  1. johnsot

    johnsot ADSM.ORG Member

    Joined:
    Jul 14, 2003
    Messages:
    95
    Likes Received:
    1
    Occupation:
    TSM Administrator for Brookshires
    Location:
    Tyler, Texas
    Does anyone have a script that I can run to tell me how fast my processes are running. I believe I have a bottle neck in TSM. (MB/s) Also does anyone have the specs for LTO2 and LTO3 tape drives? How many MB/s they are suppose to be able to run?

    Thanks,
    Tracy Johnson
     
  2.  
  3. GregE

    GregE ADSM.ORG Senior Member

    Joined:
    May 12, 2006
    Messages:
    2,100
    Likes Received:
    31
    Code:
    select process_num as PROC_NUM, process, current_timestamp-start_time as ELAPSED_TIME,(cast(files_processed as decimal(29,2)) /
    cast((current_timestamp-start_time)seconds as decimal(29,2)))as "FILES/SEC", (cast(bytes_processed/1024 as decimal(29,2)) /
    cast((current_timestamp-start_time)seconds as decimal(29,2))) as "KB/sec", cast(BYTES_PROCESSED/1024/1024/1024 as integer) as GB
    from processes
    http://www.ultrium.com/technology/generations.html
     
    Last edited: Dec 10, 2010

Share This Page