IBM Support

Maximo Asset Management on Microsoft SQL Server: Avoiding Out of Memory and Performance Problems

Troubleshooting


Problem

From Maximo 7.5 forward, Maximo/TPAE uses Microsoft's JDBC driver. By default, the Microsoft native JDBC driver fetches large amount of data into its client side JDBC connection, causing potential memory problems.

Symptom

Out of memory, performance, slow queries

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Component":"System Related","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5;7.6;7.6.1","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

More support for:
IBM Maximo Asset Management

Software version:
7.5, 7.6, 7.6.1

Document number:
473579

Modified date:
13 September 2023

UID

swg21592716

Manage My Notification Subscriptions