web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Offline Sync Service f...
Microsoft Dynamics AX (Archived)

Offline Sync Service for Retail POS in windows 10

(0) ShareShare
ReportReport
Posted on by Community Member

Dear All,

We have recently migrated from windows 7 to windows 10 on the POS and each POS use Offline database. After the migration the offline sync service randomly spikes up the CPU/Memory/Disk usage slowing down the sales performance.

Is there a way to control this High utilization of the Resources.

*This post is locked for comments

I have the same question (0)
  • Rodolfo Recalde Profile Picture
    Rodolfo Recalde on at
    RE: Offline Sync Service for Retail POS in windows 10

    Hi Syed,

    What is the version of AX / POS... R2, R3, CU 9,10,11...?

    What is the SQL Server Express version? 2012? 2014?

    What is a machine configuration that uses the POS?

    How many sales and how many sales order lines occur per minute per POS? (RetailTransactionTable, RetailTransactionSalesTrans)

    The update been made for Windows 7 for Windows 10? If yes, does this same scenario occur for a POS with Windows 10 been installed from zero?


    Some considerations.

    • I have had some strange behaviors in the POS with machines migrated from Windows 7 to Windows 10. (slowness, unexpected errors). The solution was to format machine, install Windows 10 and then install the POS - OfflineServices components. (We do not need to do this on machines migrated from Windows 8 to Windows 10. Only for machines with Windows 7)

    • Check the indexes fragmentation  in offline database. Data disorganized in the database, can burden the availability of the machine.

    • Configure Microsoft.Dynamics.Retail.Offine.Service.exe.config file

    Increase  SyncInternval  and MemoryDataCacheSizeKB. Set false in SyncInParallel, tags.

     

    • Disable Antivirus for test.  I have already solved some performance issues, excluding antivirus scan to AX component services (.exe)  and database files. See this link

    • Update the retail components to the latest version of the app if possible, or check some point-in KB like this:

    KB 3210796

    POS disks go full and POS isn't usable anymore when offline sync service emits some warnings

    Product and version: AX 2012 R3

    Fix type: Binary update

    Released Date: 12/7/2016

    PROBLEM
    When offline sync service emits some warnings, POS disks go full and POS isn't usable anymore.

    DESCRIPTION OF CHANGE
    The changes in the hotfix make sure all offline sync service logs will roll over or have a default switch value not more chatty than "Error".

    ***

    or this:

    KB 3124589

     

    High load on Store server due to Offline Synchronization

    Product and version: AX 2012 R3

    Release: CU11
    Fix type: Binary update
    Released Date: 12/10/2015
    PROBLEM
    High load is on Store server due to Offline Synchronization.
    DESCRIPTION OF CHANGE
    The changes in the hotfix resolve this issue. When RetailOfflineService is checking the time in the RetailOfflineSynclog, it logs an entry that time changed since last check and will not execute synchronization API call if it didn't reach the next sync frequency time.

    ***

    I Hope this Helps!

    Regards,

    Rodolfo Recalde.

  • Community Member Profile Picture
    Community Member on at
    RE: Offline Sync Service for Retail POS in windows 10

    Hello Rodolfo,

    Thanks for the prompt reply,

    here is the info that you have requested,

    What is the version of AX / POS... R2, R3, CU 9,10,11...?

    :-Microsoft dynamics ax 2012 R3 CU8

    What is the SQL Server Express version? 2012? 2014?

    :- 2012 Standard (as over the time the DB size crossed 10 gigs we upgraded to standard.

    What is a machine configuration that uses the POS?

    Core i3/4 GB ram and 500 GB hdd, OS is windows 10 2016 LTSB.

    How many sales and how many sales order lines occur per minute per POS? (RetailTransactionTable, RetailTransactionSalesTrans)

    Highly varied across the organization, we have around 45 stores, with uneven Customer/Sales transaction count.

    The update been made for Windows 7 for Windows 10? If yes, does this same scenario occur for a POS with Windows 10 been installed from zero?

    No we did a fresh installation and configured Retail POS from scratch.

    As far as the suggestions are concerned here are the things that we implemented already.

    I have had some strange behaviors in the POS with machines migrated from Windows 7 to Windows 10. (slowness, unexpected errors). The solution was to format machine, install Windows 10 and then install the POS - OfflineServices components. (We do not need to do this on machines migrated from Windows 8 to Windows 10. Only for machines with Windows 7).


    As i mentioned it was a fresh installation.

    Check the indexes fragmentation  in offline database. Data disorganized in the database, can burden the availability of the machine.


    We have re indexing and update stats  scheduled on all Pos on a daily basis.

    Configure Microsoft.Dynamics.Retail.Offine.Service.exe.config file

    Increase  SyncInternval :- Set to every 10 seconds as some operations required immediate replication to channel server,( not all jobs run every 10 seconds, just the important ones).

     and MemoryDataCacheSizeKB :- Doubled Already

    Set false in SyncInParallel :- Did already

    , tags:- what effect does it have?

    Disable Antivirus for test.  I have already solved some performance issues, excluding antivirus scan to AX component services (.exe)  and database files. :- Tried

    Disable GPO. :- they are not added in domain.

    Will work on the  Update  of the application.

    In our scenario the Slowness of the application is mainly due to the high disk usage by SQL and Offline sync service at times. the retailoffline log doesn't log any errors at this time. and mostly if one of the POS gets slow it effects all the other POS as well. which we temporarily solve by stopping the sync service.

    Thank you again for the support.

    Regards,

    Abdul Salaam Syed.

  • Rodolfo Recalde Profile Picture
    Rodolfo Recalde on at
    RE: Offline Sync Service for Retail POS in windows 10

    A few more considerations...

    When you say...."Microsoft Dynamics AX 2012 R3 CU8"...

    Upgrade to the latest version, all Retail components (Application, AOS,  POS, OfflineService, AsyncClient/Server, RealTimeService, ChannelDB...) is a good option. I noticed a good evolution, in previous versions (R2) and after successive updates (from the R3 CU10).


    Changing the parameters of Offine.Service.exe.config file would be an option if you did not need to synchronize every ten seconds or even in parallel. But as this is not an option for your business scenario, as you yourself have described. Maybe you can gradually increase the MemoryDataCacheSizeKB parameter, and check if there is any kind of improvement. 


    One last alternative.

    Use an SSD disk in a POS group and a store server and verify that the same behavior occurs.

    Any news, update us.

    I Hope this Helps!

    Regards,

    Rodolfo Recalde.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#1
Martin Tocauer Profile Picture

Martin Tocauer 4

#3
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans