Tim,
I am sorry IBM wasn't able to help you, (I tried to find a report
record but I couldn't)
I work for IBM support of Domino on IBM i.
I believe I can help you but I have a few questions.
How many Domino servers are running on the system?
If there is 1 server, and no other workload 4 GB sounds like more
than enough memory to support the load for 40 users.
Did anyone at IBM collect a Tprofs trace or JobWatcher trace at the time
of the problem?
If yes I would like to review that data.
Have you ever run a "SHOW MEM DUMP" ?
This generates a report of Domino memory usage, If collected after
a performance issue it should confirm the amount of memory in use.
It sounds like you are on the "right track" as your application grows, the
cost of work in the application also grows, Document count not database
size is the single biggest impact on performance (view performance), since
your application has grown 33%, the cost of doing work in your application
has also grown 33%.
A JobWatcher trace will report the current cost of a unit of work in your
application, which could then be evaluated for possible improvements and
capacity requirements.
As for your suggested actions.
1. Increase memory on the System i,
It is unlikely that would address this problem.
2. Increase CPU available the the LPAR,
I agree, based on workload it would see 1 full CPU is now
required.
3. Increase the memory on the client.
Unless your views are using LotusScript (heavily) I don't think
this would help.
Walter Scanlan
Senior Software Engineer
WPLC products for IBM i for Power Systems including AS/400, iSeries and
System i
507-286-6088
Cell: 507-990-4539
wscanlan@xxxxxxxxxx
From:
Timothy Briley <tlbriley@xxxxxxxxxxxxxx>
To:
domino400@xxxxxxxxxxxx
Date:
05/05/2008 12:41 PM
Subject:
Lotus Notes Application Performance
We use a single AS/400 9406-520 for our 45 person state agency. It
has .75 of a processor? and 4 Gigs of RAM. We installed this server
about 18 months ago and it replaced an AS/400 that we had for about
five years, so we are not new to the AS/400 platform. It's running
OS/400 v5r4 and Domino 7.02 CF1. It is primarily used for the Lotus
Notes applications which we use to pretty much run our entire agency.
Shortly after we installed this AS/400, we rolled out a pretty big
Notes application consisting of several databases. The main database
initially started out about 1.2 Gig and 300,000 documents in size,
with about 100 views.
Over time, the size of the main database has grown to 1.6 Gig and
400,000 with 114 views. But performance has really taken a hit in the
main database with many of the views taking 15 to 30 seconds to open
on a bad day and the main document taking another 30 seconds to open.
A bad day happens when about 40 users hit this Notes application.
Since we are under a maintenance contract, we've been working with
IBM to determine what to do to improve performance. They have been
unable to help in a meaningful way.
I have my own ideas about what might help:
Add more RAM to the AS/400, especially since 4 Gig doesn't seem to be
very much at all to me.
Increase the processor count from .75 (seriously, does the current
figure of .75 make sense to you?)
Increase the RAM on the PC's running the Notes clients from 512 Meg to 2
Gig.
Re-architect the main Notes database into two smaller databases.
Replace Notes views with reports where practical.
But I thought that I'd ask all of you:
If you run a Domino server on your AS/400 and have had performance
issues, what gave you more bang for the buck in improving performance?
Timothy Briley
tlbriley@xxxxxxxxxxxxxx
850 273-1433 cell
_______________________________________________
This is the Lotus Domino on the iSeries / AS400 (Domino400) mailing list
To post a message email: Domino400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/domino400
or email: Domino400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/domino400.
midrange.com
