IDS Forum

IDS 11.5 Procedures slow at seemningly random time

Posted By: George Karabotsos
Date: Thursday, 17 December 2009, at 10:52 a.m.

Hello all,

I have been spending a bit of time investigating a problem I have with
a couple of my SPL procedures. To give you some background. I have
two SPLs that are invoked through a Perl script every 10 min. Three
to seven times every 24 hour period (at seemingly random times) these
procedures run slowly, some times they take a few minutes to complete,
when all the other times it takes 10 seconds or less. I went into a
search to find out whether exclusive locks exist the cause the
slowdown--I was not able to find much and I was able to see that all
our DB work is started with
SET ISOLATION TO DIRTY READ;
SET LOCK MODE TO WAIT 5;
which seems reasonable.

What has attracted my attention is that execution from the script in
the slow runs take 8+ seconds, sometimes even 14 seconds when in the
normal cases it takes less than a second. So I am thinking whether
this is a more general problem of DB load for one reason or another at
those times.

Has anyone of you experienced similar slowdowns? Any hints, ideas
will be appreciated.

TIA,
George

Messages In This Thread

• IDS 11.5 Procedures slow at seemningly random time
  George Karabotsos -- Thursday, 17 December 2009, at 10:52 a.m.
  • Re: IDS 11.5 Procedures slow at seemningly random
    George Karabotsos -- Thursday, 17 December 2009, at 10:56 a.m.
    • Re: IDS 11.5 Procedures slow at seemningly ran....
      Art Kagel -- Thursday, 17 December 2009, at 11:11 a.m.
      • Re: IDS 11.5 Procedures slow at seemningly ran....
        George Karabotsos -- Thursday, 17 December 2009, at 11:30 a.m.
        • Re: IDS 11.5 Procedures slow at seemningly ran....
          Art Kagel -- Thursday, 17 December 2009, at 12:31 p.m.
  • Re: IDS 11.5 Procedures slow at seemningly random
    Art Kagel -- Thursday, 17 December 2009, at 11:02 a.m.
    • Re: IDS 11.5 Procedures slow at seemningly ran....
      George Karabotsos -- Thursday, 17 December 2009, at 11:07 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.