Retail Pro Prism 2 System General Maintenance and Optimization

About this Article:

This article details preventative maintenance and optimization measures that can be taken to maintain good performance in your Retail Pro installation. The article is broken down into several areas:

 

• General System and Log Maintenance
• Antivirus Exclusions
• Network- General Optimizations
• Hard Disk

 

General System and Log Maintenance:

General System Database (Oracle)

• Confirm the database has no active ORA-XXXXXX errors in the alert log
• Run the RPSTune.encrypt file prior to patching and regularly each week.
• Rename the listener.log periodically (once a week to monthly )

\Oracle\diag\tnslsnr\[hostname]\listener.log

• Set the audit_trail to none in the

\Oracle\admin\RproODS\pfile\init.ora

audit_trail=none

 

General System (All)

• Review the Windows event viewer for any errors *( such as disk i/o errors etc)
• Regularly review disk space to ensure there is enough space
• Rotate the RabbitMQ logs using the following KB 

https://my.retailpro.com/Support/Knowledgebase/?a=1001

• Make sure that the RabbitMQ Logging is configured to automatically rotate moving forward using the following KB

https://my.retailpro.com/Support/Knowledgebase/?a=905

 

Anti-Virus Exclusions:

 AV on access exclusions (Oracle systems)

[DRIVE]:\Oracle

C:\ProgramData\RetailPro

C:\Program Files (x86)\Apache Software Foundation

C:\Program Files (x86)\RabbitMQ Server

C:\Program Files (x86)\RetailPro

C:\Program Files\erl9.3

C:\Program Files\Krunch-10

 

AV on access exclusions (MySQL systems)

C:\ProgramData\MySQL

C:\Program Files\MySQL

C:\ProgramData\RetailPro

C:\Program Files (x86)\Apache Software Foundation

C:\Program Files (x86)\RabbitMQ Server

C:\Program Files (x86)\RetailPro

C:\Program Files\erl9.3

C:\Program Files\Krunch-10

 

AV on access exclusions ( Proxy only systems)

C:\Program Files (x86)\RetailPro

 

Network General Optimizations:

Network (Oracle Systems)

Whenever possible set the TNSNAME.ORA to the IP rather than the Hostname of the server. 

Located here:

• [DRIVE]:\Oracle\ODS12cr1\Network\Admin
• [DRIVE]:\Oracle\ODS12cr1Cli\Network\Admin

Likewise on the server itself set the LISTENER.ORA file to the IP rather than Hostname of the server. 

Located here:

• [DRIVE:]:\Oracle\ODS12cr1\ Network\Admin

*NOTE:  These changes require static IP assignments

 

Network (All Systems)

• Confirm that the power management options, and all "green" features are switched off on the network interface cards.
• Use 1000 Mbps NICs and Switches throughout
• Turn off P2P Windows updates ( Under delivery optimizations> Allow downloads from other PCs - Set to OFF)
• Turn off any Windows non-required diagnostics and feedback options under Settings>Privacy>Diagnostics & Feedback
• There also may be some useful configuration options in this document from Microsoft  - Performance Tuning Network Adapters | Microsoft Learn

Hard Disk:

• Separate the database to a separate physical drive from the OS.
• Use SSD/NVME drives whenever possible.
• Always maintain at least 25% free space.

Summary:

System maintenance and proper system settings are crucial for ensuring overall application performance. Regular maintenance tasks such as the ones listed above in conjunction with recommended settings will help to improve the responsiveness and reliability of the Prism application suite.