Pinned topic OPM Top SQL Report
Re: OPM Top SQL Report2012-06-27T15:37:31ZThis is the accepted answer. This is the accepted answer.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.
Re: OPM Top SQL Report2013-08-07T19:50:32ZThis is the accepted answer. This is the accepted answer.
- ruhido 120000JKT9
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.