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:
SCCD 7.5.1 Performance Education Session
Correcting Slow User Queries
So you and your team are ready to make the leap on to the next release of Maximo or SCCD but, there is that looming concern about what is going to happen when you flip the "ON" switch on your go-live date. Will it work? Will performance be acceptable? or will you have to find a safe house to hide from the angry mob of users that can not use the system? You are not alone. Those are the type of questions that keep every Project Manager and System Implementer up at night.
Through collaboration with some of our... [More]
"Before you can race, you must qualify". As a fan of Motorsports (Formula 1 in particular) I hear this phrase on many weekends throughout the season. The phrase basically means that to have the highest chance of being successful in an endeavor you must prepare adequately. In this article I shall take this same idea and show you how to apply it to a successful Maximo installation.
If "qualifying" is preparing for a race then careful planning of your IBM Maximo Administrative Workstation is along the same lines. Many... [More]
I need to set limits when faced with these. Knows as Fluffernutters, smooth, decadent peanut butter and sticky marshmallow topping on plain white bread form the ultimate comfort sandwich. With a cold glass of milk, the number I can toss down is crazy high.
You may also need to stop your users from over-indulging by setting records limits when they create Ad Hoc or QBR (Query Based Reports.) The creation process of ad hoc reporting is where users select the fields, application query,... [More]
When following the current Best Practices for Performance white paper, one of the Generic JVM arguments that is recommended is to set the -Xdisableexplicitgc parameter. Setting this parameter turns a System.gc() call into a no-op.
This parameter works well for the vast majority of our clients. However, there have been a few cases where JVM memory is fairly tight due to the specific workloads that the end users are generating. In some cases, requests for object memory grow faster than the Java virtual machines decides to... [More]
If you're looking for ways to optimize system performance, consider enabling data compression on the IBM HTTP server. You can use the Apache mod_deflate module to improve response time in
environments that have low bandwidth and high latency. The Apache
mod_deflate module compresses output from your server before the data is
sent to the client over the network.
Setting the compression level is to 3 provides minimal CPU usage and
a decent benefit from the compression. You can also set the compression
level to 6, which provides... [More]
Do you collect coins? In a gargantuan container that once held a supersize collection of cheese puffs? My mammoth 24 x 8 inch plastic container was so packed full of coins, it broke thru its bottom when I recently tried relocating it... Maybe relocating wasn’t the best plan for the coins….which is just one of the many collections I’ve shared with you this year. Others included post cards , National Park Stamps , photos , and BiLog entries! Yes! BiLogs are a collection of Maximo Business Intelligence Blogs detailing reporting... [More]
The other day, we encountered a problem during one of our performance tests. We observed from the database side that there is a steady increase of connections over time. Of course, we immediately suspected there is a newly introduced connection leak somewhere and started the hunt. The very first thing we did was to turn on the dbconnection logger to info level. We confirmed from the maximo logs that these connections indeed are recorded in the maximo connection pool as used connections and not released. The stacktrace did confirm that there... [More]
In a large scaled Maximo environment, some of us would use IBM DB2 pureScale database. As the more nodes you have, the more contentions there are on every kind of resources. Normally, Maximo is using Sequence object inside database to avoid the locking issues that are associated with other more heavier approaches In a standard database, Maximo usually cache some sequence values in memory to improve response time. While in a DB2 pureScale environment, if both CACHE and ORDER are specified, the specification of ORDER overrides the specification... [More]
In Maximo Version 188.8.131.52, the
information center provides new instructions for optimizing system
performance. You can learn how to find the optimal heap size for
WebSphere® Application Server and how to configure
performance-related settings in DB2®. You can also learn more about
general database optimization techniques that you can use in any
database, such as customizing queries and setting sequence caches.
The new instructions also
provide detailed information on designing performance tests, which
can help you discover optimal... [More]
The database is central to the functionality of IBM Tivoli service management products. It stores all data that is collected and calculated by the applications. This database also stores metadata for configuring and maintaining the environment. Reporting also generates resource-intensive management reports. Because all functionality is based on database performance, the database can be a key focus for performance tuning. SQL query tuning and creating indexes against a database can help to obtain maximum performance from IBM Tivoli service... [More]
Performance Analyst is a tool aimed to make performance analysis manageable. Performance analysis is all about data, I mean, large amount of data . Sometime there might be days of application logs and performance data for us to sort out the reason why it slowed down or even crashed. Other times we might have to figure out what's wrong with the slow database server and queries, given a few hundred mega bytes of database snapshot data. Humans are good at detecting peculiarities and finding out the symptoms of problems, but our eyes are not made... [More]
Are you trying to use Rational Performance Tester (RPT) to do performance testing on deployments of IBM Tivoli system management products and running into roadblocks? Are you not even sure where to begin with your performance testing effort? Look no further than the Performance Test Best Practices for Rational Performance Tester white paper available in the Asset Management Files area of Service Management Connect! This white paper explains how to define your test methodology, the types of performance tests you may want to do, how to develop... [More]
Ever faced performance problems when exporting large volumes of data using Publish Channels? Does these symptoms look familiar - "my export was working fine when I was doing in batches of 100 or 200 - but when I started doing 500 records at a time the performance degraded!" Maybe its a good time to look at your Publish Channel setup. Turning off “Retain Mbo's” is one such setup in the channel that might help you get better performance out of your data export. For more on this please refer to this link .
Maximo is everywhere! It has been around for several decades and is in use by many different industries of all sizes. Client databases have grown in size and complexity over the years. Continued monitoring of database integrity is always recommended to make sure all your I’s are dotted and T’s are crossed. Just the other day I was talking to a client that was experiencing major slowness in performance while generating a handful of Work Orders from the Preventive Maintenance application. They were attempting to generate about 5 work... [More]