Automic Workload Automation

  • Private Community

  • 1.  Please share your WP's average performance ratings

    Posted Nov 15, 2016 02:23 AM
    Hi

    I am interested to know what DB performance other community members are getting from their systems. 

    The info is in the WP logs just after startup at msg U00003533.  It is followed by a reference system performance value msg U00003544  where the DB is on same server as app (so reference system has little or no network distance)

    20161115/130251.048 - U00003533 UCUDB: Check of data source finished: No errors. Performance CPU/DB: '33343231'/'72'
    20161115/130251.048 - U00003544 UCUDB: Reference values tested with Windows 2003 on XEON 1500 MHz: CPU 813865, DB 470

    Regards,
    Matt



  • 2.  Please share your WP's average performance ratings
    Best Answer

    Posted Nov 15, 2016 12:32 PM
    We are running V11.2.1 on Windows 2012 and SQLServer 2014.

    20161111/112537.000 - U00003533 UCUDB: Check of data source finished: No errors. Performance CPU/DB: '57811749'/'775'
    20161111/112537.000 - U00003544 UCUDB: Reference values tested with Windows 2003 on XEON 1500 MHz: CPU 813865, DB 470



  • 3.  Please share your WP's average performance ratings

    Posted Nov 15, 2016 02:35 PM
    Windows 2012 R2 and SQLServer 2012.

    DEV AE 11.2.2 HF7 (DB on different server)
    20161110/105119.006 - U00003533 UCUDB: Check of data source finished: No errors. Performance CPU/DB: '66940825'/'834'

    PROD AE 10.0.5 (DB on different server)
    20161112/073837.203 - 20161103/011010.005 - U0003533 UCUDB: Check of data source finished: No errors. Performance CPU/DB: '63481649'/'803'


    Here is numbers I've seen from "ONE Installer" installation on Virtualized Windows 7 with local to the same machine SQLServer Express 2014
    AE 11.2.2 HF3
    20161115/032203.012 - U00003533 UCUDB: Check of data source finished: No errors. Performance CPU/DB: '46710582'/'1269'


    Just want to note that different WPs reports may have somewhat different values.


  • 4.  Please share your WP's average performance ratings

    Posted Nov 17, 2016 01:52 AM
    Thanks for replying.  We have found some bottlenecks in load balancer for our DB storage and now going to move the DB to extreme IO SSD.    Hopefully I can post some higher values after the move.
    700+ would be nice!! 

    AE 11.2 on RHEL connecting to Oracle DB on separate servers  (with the load balance storage issue)
    20161115/130251.048 - U00003533 UCUDB: Check of data source finished: No errors. Performance CPU/DB: '33343231'/'72'