How can we help you today? How can we help you today?

Job duration unusual - Baseline incorrectly calculated

Just installed SQL response for evaluation and testing and getting a low priority alert for Job duration unusual which seems to be because the baseline duration has been incorrectly calculated. The last 10 runs show a duration of 19s, 20s, 22s, 19s, 20s, 20s, 19s, 22s, 21s and 21s but the baseline duration calculated is 250.20s, the current run duration is 21.00s? The average of the above 10 jobs is 20.3s?

See link for screenshot of issue

http://net2005.myby.co.uk/sqlresponse.png

Thanks

Andrew
Andrew Hodge
0

Comments

8 comments

  • Isobel Hooper
    I agree, that baseline calculation does seem to be rather out.

    Thank you for letting us know about this - one of our developers is off today, but he will have a look at it tomorrow and we will see if we can reproduce it.
    Isobel Hooper
    0
  • Andrew Hodge
    Another occurrence of this problem on a different job

    sqlresponse2.jpg
    Andrew Hodge
    0
  • Andrew Hodge
    And another

    sqlresponse3.jpg
    Andrew Hodge
    0
  • Isobel Hooper
    Thank you for the further examples - we have logged it in our bug track system.
    Isobel Hooper
    0
  • dlkj
    Hi Andrew,

    I've managed to reproduce the issue and I'm currently working on a fix.

    Thanks for your help.
    --
    Daniel
    dlkj
    0
  • laker_42
    Daniel,
    Any idea when we can expect a fix for this? I am experiencing the same issue

    John
    laker_42
    0
  • dlkj
    Hi John, Andrew,

    I've submitted a fix for this issue. Once this has be tested, it should be included in a point release hopefully some time next month.

    Cheers,
    --
    Daniel
    dlkj
    0
  • Eddie D
    SQL Response Version 1.1 has fixed this particular problem.

    Many Thanks
    Eddie
    Eddie D
    0

Add comment

Please sign in to leave a comment.