Topic
  • 3 replies
  • Latest Post - ‏2013-08-07T19:50:32Z by dbabob
dbabob
dbabob
3 Posts

Pinned topic OPM Top SQL Report

‏2012-06-27T15:15:36Z |
I'm questioning the Rows Modified value in the Top SQL Report in OPM. I'm looking at a single record insert statement (insert into TABLE values (...)) that exeucutes 747,978 times so I would expect the Rows Modified to be about the same (747,978) if there were no failures. But the value for Rows Modified is only 428,843. The application team is assuring me they are not seeing that many failures. The only other thing I can think of that would cause this discrepancy is the fact that we have 5 database partitions and we are only monitoring 3 partitions. Perhaps the Rows Modified isn't being incremented for the records that are inserted on the two partitions that aren't being monitored by OPM. Has anyone else experienced or have any insight to this? Any help would be appreciated.
Updated on 2012-06-27T15:37:31Z at 2012-06-27T15:37:31Z by dbabob
  • dbabob
    dbabob
    3 Posts

    Re: OPM Top SQL Report

    ‏2012-06-27T15:37:31Z  
    I have one correction. I'm actually monitoring all the data partitions in OPM so now I have no idea why there is such a big difference between # of executions and rows modified for a singe record insert. I've included a PDF of the report. The insert I'm referring to is query #3 in the report.
  • ruhido
    ruhido
    6 Posts

    Re: OPM Top SQL Report

    ‏2013-08-07T19:08:28Z  
    • dbabob
    • ‏2012-06-27T15:37:31Z
    I have one correction. I'm actually monitoring all the data partitions in OPM so now I have no idea why there is such a big difference between # of executions and rows modified for a singe record insert. I've included a PDF of the report. The insert I'm referring to is query #3 in the report.

    Hi dbabob,

    did you manage to find the root-cause for the rows modified discrepancy?

    Regards

  • dbabob
    dbabob
    3 Posts

    Re: OPM Top SQL Report

    ‏2013-08-07T19:50:32Z  
    • ruhido
    • ‏2013-08-07T19:08:28Z

    Hi dbabob,

    did you manage to find the root-cause for the rows modified discrepancy?

    Regards

    No but I have some guesses.

    It may be because the database is partitioned and perhaps some of the partitions aren't counted.

    It could also be due to the application's use of batch inserts.  Maybe these aren't summed up correctly behind the covers for some reason.