Maximo List Archive

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.



Re: Maximo Performance

From: foundationboarder187 (2013-01-25 12:56)

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
>


From: Hanna, Christopher CTR (2013-01-25 08:06)

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 <mailto:MAXIMO%40yahoogroups.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
>


From: George (2013-01-25 13:34)

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
> >
>


From: Chris Lawless (2013-01-25 08:22)

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 <ggutierrez@pasadenarefining.com>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
> > >
> >
>
>
>


From: jhale1996 (2013-01-27 01:07)

Our servers are 64bit.
We typically run 50-60 users.
Thanks for the idea to look at the DB server. I'll follow up with our DBA.
We are running MS Forefront. I am working on excluding all of the IBM directories from AV scanning.
--- 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
> >
>


From: Chris Lawless (2013-01-26 20:17)

If you only have 50-60 users I'd be inclined to either shutdown two JVMs or, maybe more cautious, set the initial heap size to 2Gb on all five and monitor if it grows. I've just seen an almost identical scenario at another client.
Reducing the initial memory will cause the heap to grow as required and give you a clearer picture of what you need to support your users. You can chart the heap usage from native_stderr.log using the IBM Support Assistant.
Chris.
On Jan 26, 2013, at 8:07 PM, "jhale1996" <jhale1996@yahoo.com> wrote:
> Our servers are 64bit.
> We typically run 50-60 users.
> Thanks for the idea to look at the DB server. I'll follow up with our DBA.
> We are running MS Forefront. I am working on excluding all of the IBM directories from AV scanning.
>
> --- 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
> > >
> >
>
>