Automic Workload Automation

  • Private Community

  • 1.  Data Source Performance Metrics

    Posted Jan 05, 2017 08:23 AM
    I've seen people talk about the values in "U00003533 UCUDB: Check of data source finished: No errors. Performance CPU/DB:" and that it should be better than 470 or in between 180 and 220, but I havent found what this is measuring and is lower or higher better?


  • 2.  Data Source Performance Metrics

    Posted Jan 05, 2017 09:36 AM
    Hi BrandonMcClure610423

    The first number is the amount of times that the CPU can add 1+1 within 2 seconds.

    The second number is how often the AE does an ‘INSERT INTO DIVDB’ and ‘SELECT from DIVDB’ within 2 seconds.

    Higher values indeed correspond to a better performing system.

    Best regards,

    Antoine



  • 3.  Data Source Performance Metrics

    Posted Jan 05, 2017 09:37 AM
    You may find this post that Harriet_Kim_1764 did interresting: https://community.automic.com/discussion/7455/how-to-determine-your-oracle-dbs-i-o-benchmark

    Best regards
    Antoine


  • 4.  Data Source Performance Metrics

    Posted Jan 05, 2017 09:39 AM
    perfect


  • 5.  Data Source Performance Metrics

    Posted Jan 05, 2017 04:36 PM
    for a TEST or DEV environment a value below this 470 won´t be a big issue but in PROD env I would spend some bucks for new or faster hardware :-)

    BTW: I had an USB drive with virtualbox on it and an SQL Server and V9 running in that sandbox - plugged to my win8 netbook

    THAT was hmmm... "quite slow" with a value of 18

    :-)


  • 6.  Data Source Performance Metrics

    Posted Jan 09, 2017 08:50 AM
    that is what is scaring me, my v11.2 system that I'm migrating to is at 17 :( 
    I'm working with support now on this


  • 7.  Data Source Performance Metrics

    Posted Jan 10, 2017 04:09 AM
    I bet support´s answer will be "please use more powerful servers" :-)