Database Transaction 2 Workload Run

Test Version - 0.21

  • Kernel Version - 2.4.23 build klondike1
  • SAP DB Version - 7.3.0.25
  • Intel(R) Xeon(TM) 2 Physical CPUs @ 3.06GHz
  • with 4GB memory
  • IO is RAW using 1 Data device and 1 Log device
  • Run Type: CACHED HT 4 Log--2 Phys at 2.4.23 kernel; Report: Generated from data on klndk1-srv
  • Warehouses - 100
  • Drivers - 8
  • Spread - 2
  • List of performance statistics for CACHED HT 4 Log--2 Phys at 2.4.23 kernel 2.4.23 build klondike1

    Sample interval 60 seconds for all statistics

    Run metric is NOTPM, New Order Transactions per Minute (bigger is better)

    CPU load (user time)

    NOTMP

    Summary diagrams:

    Processes Waiting for Run Time
    Processes in Uninterruptable Sleep
    Virtual Memory Used (kB)
    Idle Memory (kB)
    Memory Used as Buffers (kB)
    Memory Used as Cache (kB)
    Memory Swapped in from Disk (kB/s)
    Memory Swapped to Disk (kB/s)
    Blocks Received from a Block Device (blocks/s)
    Blocks Sent to a Block Device (blocks/s)
    Interrupts per Second, including the Clock
    Context Switches per Second
    User Time as Percent of Total CPU Time
    System Time as Percent of Total CPU Time
    Idle Time as Percent of Total CPU Time
    Wait I/O as Percent of Total CPU Time
    NOTPM per minute


    RUN ID w100_c300000_rest3600

  • NOTPM (metric) - 3109.28
  • cpu
  • not
  • proc
  • vmstat
  • notpm
  • results
  • readprofile
  • param
  • ipcs0.out knldiag.out knldiag_shutdown.out lockstats.out x_cons.out (large files in one archive)


  • RUN ID w100_c300000_rest3600__2

  • NOTPM (metric) - 3119.16
  • cpu
  • not
  • proc
  • vmstat
  • notpm
  • results
  • readprofile
  • param
  • ipcs0.out knldiag.out knldiag_shutdown.out lockstats.out x_cons.out (large files in one archive)


  • RUN ID w100_c300000_rest3600__3

  • NOTPM (metric) - 3129.06
  • cpu
  • not
  • proc
  • vmstat
  • notpm
  • results
  • readprofile
  • param
  • ipcs0.out knldiag.out knldiag_shutdown.out lockstats.out x_cons.out (large files in one archive)


  • RUN ID w100_c300000_rest3600__4

  • NOTPM (metric) - 3127.00
  • cpu
  • not
  • proc
  • vmstat
  • notpm
  • results
  • readprofile
  • param
  • ipcs0.out knldiag.out knldiag_shutdown.out lockstats.out x_cons.out (large files in one archive)


  • RUN ID w100_c310000_rest3600

  • NOTPM (metric) - 3097.36
  • cpu
  • not
  • proc
  • vmstat
  • notpm
  • results
  • readprofile
  • param
  • ipcs0.out knldiag.out knldiag_shutdown.out lockstats.out x_cons.out (large files in one archive)


  • RUN ID w100_c320000_rest3600

  • NOTPM (metric) - 3157.87
  • cpu
  • not
  • proc
  • vmstat
  • notpm
  • results
  • readprofile
  • param
  • ipcs0.out knldiag.out knldiag_shutdown.out lockstats.out x_cons.out (large files in one archive)


  • RUN ID w100_c330000_rest3600

  • NOTPM (metric) - 3104.14
  • cpu
  • not
  • proc
  • vmstat
  • notpm
  • results
  • readprofile
  • param
  • ipcs0.out knldiag.out knldiag_shutdown.out lockstats.out x_cons.out (large files in one archive)


  • RUN ID w100_c340000_rest3600

  • NOTPM (metric) - 3109.96
  • cpu
  • not
  • proc
  • vmstat
  • notpm
  • results
  • readprofile
  • param
  • ipcs0.out knldiag.out knldiag_shutdown.out lockstats.out x_cons.out (large files in one archive)