Environment: iVend 6.6 with S4 HANA 1609

Problem Statement: Store server performance daily issue at 12:00 AM. At midnight the store server performance becomes very bad and it is found that SQL server service consumes the I/O resources especially the hard disk. The disk response time goes in millions.

Error Screenshot:

​

Symptoms: The store server performance becomes very bad and it is found that SQL server service consumes the I/O resources especially the hard disk. The disk response time goes in millions.

Resolution/Work Around:

There is a job that clears all replication logs except for last 15 days. This job is executed every midnight at 12:00 am. When this job executed store server is stuck because of high consumption of I/O resources.

Solution: -

Changes in the replication web configuration is done to execute the job at 03:00 am (stores downtime or when the customer footfall is very low) instead of 12:00 am and the replication logs were cleared except of last two days.

Below are the parameters which were changed in configuration file.

********************* Old Configuration **************************

<add key="RunReplicationCleanJobAtTime" value="0" /> *** This is in 24 hr format.***
<add key="CleanReplicationDataSendLogAfterDays" value="15" />
<add key="CleanReplicationReceiveDataLogAfterDays" value="15" />

*********** The above parameters should be changed to ***********

<add key="RunReplicationCleanJobAtTime" value="3" />

<add key="CleanReplicationDataSendLogAfterDays" value="2" />
<add key="CleanReplicationReceiveDataLogAfterDays" value="2" />