1. Please help support our sponsors by considering their products and services.
    Our sponsors enable us to maintain high-speed Internet connection and fast webservers.
    They support this free information and knowledge exchange forum service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions

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