Body

Once in a while I'll get questions about performance problems.  Specific scenarios can be resolved by applying Interim Fixes or adding indexes.  Those critical and urgent problems often happen throughout the entire system.

Here is a collection of performance related recordings and technotes that might help:

Install Performance Monitor

https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM%20Maximo%20Asset%20Management/page/Interactive%20Performance%20Analysis%20with%20Maximo%20Activity%20Dashboard%20%28MAD%29

Clustering with Maximo and WebSphere 8.5.5

Three part series with step by step instructions and screen shots

https://www.ibm.com/developerworks/community/blogs/a9ba1efe-b731-4317-9724-a181d6155e3a/entry/clustering_with_maximo_part_1_configuring_websphere_8_5_5?lang=en

SCCD 7.5.1 Performance Education Session

http://www-01.ibm.com/support/docview.wss?rs=0&uid=swg27038763

Correcting Slow User Queries

http://www-01.ibm.com/support/docview.wss?uid=swg27038272

/support/pages/node/243867

Maximo Performance Best Practices

/support/pages/node/611023

Best Practices for System Performanc​e 7.5

https://www.ibm.com/developerworks/mydeveloperworks/groups/service/html/communityview?communityUuid=a9ba1efe-b731-4317-9724-a181d6155e3a#fullpageWidgetId=W5f281fe58c09_49c7_9fa4_e094f86b7e98&file=c51d5f5b-dea3-4043-a81f-d5213fc10063

JVM Separation Process

/support/pages/node/462849

Out Of Memory errors on the systemout.log

 /support/pages/node/159105

Out of Memory blog

/support/pages/node/1129473

Database Connection leak

/support/pages/node/216327

Using System Instance Properties to Control Cron Tasks

/support/pages/node/195511

Parameters to improve Maximo performance using WebSphere

/support/pages/node/348001

Stopping Data from Auto-populating List Tab

/support/pages/node/219073

Configuring Autofill Properties

WebSphere 7.0 fixpack 27 or higher with Java SDK 1.6.0 SR12 Cumulative Fix

/support/pages/node/197777

Understanding Memory Requirements For 32 And 64 Bit Systems

/support/pages/node/127685

Understanding Search Methodologies

http://www-01.ibm.com/support/docview.wss?uid=swg21321289&lnk=uctug_tivoli_nwsltr_MAM

More performance technotes:

http://www-947.ibm.com/support/entry/portal/search_results/tivoli/maximo_asset_management?sn=spe&sortby=-dcdate&filter=&ibmprd=SCCDLP&q=tpaeperformance&productContext=-2077426143#q%3Dtpaeperformance%26sortby%3D-dcdate%26filter%3Dlanguage%3Aen

 SQL SPECIFIC Technotes:

Maximo Performance on SQL Server - Turning off Page Locking

/support/pages/node/350661

Maximo 7.5 on SQL Server out of memory and performance problems

/support/pages/node/473579
 

ORACLE SPECIFIC TUNING:

create indexes and use the recommended settings for Oracle 10g and 11g below:
 

• cursor_sharing - We highly recommend that this be set to FORCE for optimal performance in Maximo. Currently, the value is set to EXACT
• processes - make sure this value is high enough to handle all of the concurrent connections expected to the database. We generally recommend 4000
• sessions - we generally recommend keeping this the same as processes, e.g. 4000
• transactions - we recommend this be set to 2425
• session_cached_cursors - the recommended value is 400
• session_max_open_files - the recommended value is 300
• nls_length_semantics - if you use Unicode or double-byte, then you would want to set this value to CHAR