This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Chris -
Thanks for the great info.
Quick info on my architecture. A virtualized J2EE server containing 4 application servers running in a cluster to service reporting, crons, and integration. Remote users sign in to seperate J2EE server with 3 application servers clustered serving the UI application only.
Many users complaining about poor response time generating reports. However in the report usage log table the runtime value is rarely over 5 seconds and often 1-2.
Yet, looking at the system.out file for an app server on the report server, I'm seeing execution times repeatedly exceeding 1000ms. Could you comment what other things should be considered and what my next step of analysis should be.
Thank you so much!
--- In MAXIMO@yahoogroups.com, Chris Lawless wrote:
>
> The two main areas you should focus on are the application server and the
> database, with the correct things enabled they will report how well things
> are doing and give you a lot of pointers as to where to look.
>
> Application Server:
> 1. Is the server swapping to disk? You may have oversubscribed the
> available memory which would cause swapping and have a major impact on
> performance. A good option in conjunction with monitoring the heap is to
> reduce the initial heap size then watch to see if it eases the load (from a
> memory perspective) on the server.
> 2. Heap logging - either track the available memory reported in
> SystemOut.log or enable verbose garbage collection logging in WebSphere. Do
> you really need 5 JVMS or are you allocation 4Gb of memory to each and
> having it just sit there doing nothing?
> 3. User distribution - the benefits of your five JVMs are wasted if your
> load balancing isn't working, track via SystemOut.log the number of users
> per JVM and ensure you are not saturating one JVM.
>
> Database:
> 1. Ensure that SQLTimeout in Maximo Properties is set to 1000 or a little
> less, look through your SystemOut.log files and search for the phrase
> "execution took", this will show any queries for which the round trip to
> the database too more than 1000 milliseconds, look at optimizing any that
> you find.
> 2. Database server - does it have enough memory? For example on Oracle
> check the SGA and PGA sizes, also ensure that there is enough physical
> memory available to meet what is allocated.
>
> Chris.
>
>
>
> On Fri, Jan 25, 2013 at 7:34 AM, George wrote:
>
> > **
> >
> >
> > If I may ask since we don't have a DBA what can be used to monitor the
> > activity on the DB. We are having the same issues.
> > What are the exclusions needed within the anti virus?
> >
> > thx,
> > mrggutz
> >
> >
> > --- In MAXIMO@yahoogroups.com, "Hanna, Christopher CTR" wrote:
> > >
> > > Are your servers 32bit or 64bit?
> > > What is your average concurrent usage?
> > > My guess would be that the issue is with your DB, nine times out of ten
> > that's where I find performance bottlenecks. Can your DBA see what the
> > activity on the DB looks like when issues are occurring?
> > > One other thing to look at is your Anti Virus SW on the server. Make
> > sure exclusions are set up for the appropriate directories. McAffee/Norton
> > will eat your lunch if you let them.
> > >
> > >
> > > -----Original Message-----
> > > From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf
> > Of foundationboarder187
> > > Sent: Friday, January 25, 2013 7:57 AM
> > > To: MAXIMO@yahoogroups.com
> > > Subject: [MAXIMO List] Re: Maximo Performance
> > >
> > >
> > >
> > > What is running on each of your end user terminals?
> > >
> > > Browser (IE, Chrome, Firefox, etc)
> > > Java Version
> > > Memmory on the PC ( I believe IBM recommends 2 gig)
> > >
> > > -Todd
> > >
> > > --- In MAXIMO@yahoogroups.com , "jhale1996" wrote:
> > > >
> > > > Fellow Maximo users,
> > > >
> > > > The City of Bellevue is working to improve Maximo 7.5 system
> > performance and would like to know your experience with tuning Maximo. Here
> > is what our users are experiencing:
> > > > User sessions timeout
> > > > Slow to return results(user query)
> > > > Slow to tab between fields
> > > > Slow to show value lists
> > > > Start centers slow to load
> > > > Long running processes fail to refresh screen Hour glass/freezes
> > > > random times Running large/complex queries affect other users
> > > >
> > > > Our current environment runs on Windows 2008 R2 servers. We run
> > WebSphere 7.0.0.15 and MS SQL 2008. Our users connect to one of 5 JVMs
> > running on the same physical server (2 quad core 32GB ram). On the same
> > server we have one JVM dedicated to inbound transactions and Cron tasks.
> > Print jobs are handled by a JVM running on a seperate physical server. All
> > sites are connected with fiber, 1Gb to the servers and 100Mb cooper to the
> > desktop.
> > > >
> > > > We would appreciate any input - and we are happy to reciprocate.
> > > >
> > > > Jason Hale
> > > > IT Analyst
> > > > City of Bellevue
> > > >
> > >
> >
> >
> >
>
>
>
>