Optimize SQL Server 2005 with Maximo 6.1 or above

Written by Chon Neth, Editor-in-Chief

To help improve performance on SQL Server 2005 with Maximo 6.1 or above use this settings in the maximo.properties file:

mxe.db.disableservercursor=Y
mxe.db.resultsettype=TYPE_FAST_FORWARD
mxe.db.fetchsizeuse=Y
mxe.db.fetchsize=40
mxe.db.optionuse = Y
mxe.db.optionnum=1000
mxe.db.sqlserverPrefetchRows=200

For more details, visit IBM Support.

Did You Know...

As Maximo Experts, we have developed several add-on products for Maximo that mobilize the work force, simplifies assignments, provides ad-hoc reporting capabilities and facilitates the seamless integration of Service Requests into Maximo.

Check out our products by clicking on the following links: EZMaxMobile, EZMaxPlanner and EZMaxRequest.

Find Out More

Leave a Reply