Setting up the memory usage in Sage ERP X3

By | July 31, 2014

In one of previous blog name we had discussed about the Memory setting option available in Sage ERP X3. Here we will discuss in detail about all the options available under this setup.

New Stuff: How to change Entry Transaction without exiting the screen?

Memory consumption is the key factor for any development. If our process is consuming too much memory which is resulting in slowness of system then it is a big problem. Sage ERP X3 gives us the feasibility to set the memory limit for the running process, local data, no. of tables used and so on. We can look into all this factors one by one:

We can set this memory in: Setup > General parameter > Folders

mem-1Under the “Miscellaneous” tab of this window we can define the memory distribution for different threads in X3.

Engine process memory (MB): This parameter corresponds to the memory size used for the local data during the execution of the server process. By default, 16 Mb is proposed, this is a reasonable value even if the minimum value possible is 4 Mb. It is possible to increase it as a function of the maximum number of lines used for the large tables in memory (orders, invoices, postings). The higher the given values in the Screens tab, the greater the need to increase the necessary memory size. The system variable “maxmem” is used to identify the current value during a session.

Database process memory (MB): This field is used to define the memory size allocated to the process accessing the database (it is named “sadora” or ‘sadoss” according to the database). The default value is set to 20Mb, which only needs changing on rare occasions. The system variable “sadmem” is used to identify the current value in a session in execution.

Programs: This parameter is used to define the maximum number of processes opened simultaneously in a software session. The default value is 200, the minimum value being 100. A higher number will improve the performances by limiting the reloading of processes. The system variable “adxmpr” is used to identify the current value during a session.

Open Tables: This parameter is used to define the maximum number of tables in the database simultaneously on line in a software session. The default value is 150 and it is appropriate in most cases. The system variable “adxmto” is used to know the current value during a session.

Sequential Files: This field is used to define the maximum number of sequential files open simultaneously in a software session (by the instructions “Openi”, “Openo”, “Openio”). The default value is 10, the minimum value being 10. Except to very specific cases linked to these instructions, this value has no reason to be modified. The system variable “adxmso” is used to identify the current value during a session.

[Note:] As this is set up in the folders option, the validation will require after the changes made and validation of folder may take 5 to 6 hours for completion. So for feasibility, this option should be used at the time of setting up a new folder.

About Us
Greytrix – a globally recognized Premier Sage Gold Development Partner is a one-stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development and implementation expertise.

Greytrix caters to a wide range of Sage Enterprise Management (Sage X3) offerings – a Sage Business Cloud Solution. Our unique GUMU™ integrations include Sage Enterprise Management (Sage X3) for Sage CRMSalesforce.com and Magento eCommerce along with Implementation and Technical Support worldwide for Sage Enterprise Management (Sage X3). Currently we are Sage Enterprise Management Implementation Partner in East Africa, Middles East, Australia, Asia. We also offer best-in-class Sage X3 customization and development services, integrated applications such as POS | WMS | Payment Gateway | Shipping System | Business Intelligence | eCommerce and have developed add-ons such as Catch – Weight  and Letter of Credit for Sage Enterprise Management to Sage business partners, end users and Sage PSG worldwide.

Greytrix is a recognized Sage Rockstar ISV Partner for GUMU™ Sage Enterprise Management – Sage CRM integration also listed on Sage Marketplace; GUMU™ integration for Sage Enterprise Management – Salesforce is a 5-star app listed on Salesforce AppExchange.

For more information on Sage X3 Integration and Services, please contact us at x3@greytrix.com. We will be glad to assist you.