Skip to main content

Notifications

Microsoft Dynamics RMS (Archived)

Number of items slowing Store Ops

Posted on by Microsoft Employee

I have a customer who has 53,000 items in their database... could this cause slowdowns?

When an item is added to a purchase order it takes roughly 1-2 seconds to appear in the list... this is my only customer with this many items and I'm wondering whether doing an item cleanup will resolve this issue...? Ideas?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Number of items slowing Store Ops

    I would recommend checking the size of your database.    Were those items imported?   large transactions?   is it sql server 2005?    We upgraded the server and it made a big difference.    We also cleaned up the items and deleted 5+ year old transactions.    

  • raelhefn Profile Picture
    raelhefn on at
    RE: Number of items slowing Store Ops

    to resolve Slowdowns RMS lookups

    1- Check database log (Shrink it if it's size very huge before shrink make its recovery mode simple)

    2- Run Reindex database from store operation administrator and check database

    3- Add some indexes to your database tables (item, etc...) if not all of above resolve your issue

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Number of items slowing Store Ops

    Thanks. I will try that when store is closed remotely.

  • raelhefn Profile Picture
    raelhefn on at
    RE: Number of items slowing Store Ops

    Before you run indexing on database close any related rms apps hq client and som

    run check database and reindex it again

  • Suggested answer
    Jeff @ Check Point Software Profile Picture
    Jeff @ Check Point ... 13,380 on at
    RE: Number of items slowing Store Ops

    My HQ database doesn't have a StoreTaxes table.  Maybe an add-on was installed/uninstalled.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Number of items slowing Store Ops

    Yes, it was originally deployed in HQ. RMS replaced an existing system for this business and they have 7 stores. No import tools were used.

  • RMS Wizard Profile Picture
    RMS Wizard 1,205 on at
    RE: Number of items slowing Store Ops

    That is why I asked how system was originally deployed in HQ and whether any SQL tools were used to insert data.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Number of items slowing Store Ops

    Your suggestion seems reasonable. Sort of surprised that the table is missing and that everything else is functioning...

  • Suggested answer
    Antonijo Todorovik Profile Picture
    Antonijo Todorovik 4,025 on at
    RE: Number of items slowing Store Ops

    Do You know what was the previous version, before CU5 was installed?? Any changes in the Tax data before the CU5 update? Do You maybe have a backup of the database before the CU5 update, so we can restore and compare? To be honest, this [StoreTaxes] table, makes me worry... do You have any 3rd party add-on installed maybe??? This error normally happends when a "object" in SQL database is missing...

    Hope we are going to the right direction with the tip...

    Regards, A.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Number of items slowing Store Ops

    Its at CU5 right now. Updates were deployed system-wide as they were available.

    SQL 2008 R2

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans