Skip to main content

Notifications

Microsoft Dynamics RMS (Archived)

MS RMS Headquarter Detail Sale report is very slow

Posted on by 750

Hi all,

I am facing a problem in MS RMS headquarter. When i am taking the Detailed Sales report RMS is going to hanged and after some time it gives me the error of timeout. Please help me to solve this issue. We are using Microsoft RMS 2.0 SP 4.

Our current data size is 1GB.

Thanks Umar

*This post is locked for comments

  • Umar Khitab Profile Picture
    Umar Khitab 750 on at
    RE: MS RMS Headquarter Detail Sale report is very slow

    Thanks for your reply. We are doing the same it impact on the speed. can you please help me to reduce the size of my database

    Thanks in Advance

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: MS RMS Headquarter Detail Sale report is very slow

    You can always make a Maintenance Plan in SQL Server to rebuild index on daily basis instead of upgrading RMS or even installing new service packs

    I had the same issue and the Rebuild index solved it.

  • Umar Khitab Profile Picture
    Umar Khitab 750 on at
    RE: MS RMS Headquarter Detail Sale report is very slow

    We are using FB2 RETAIL2.0-KB2727850

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: MS RMS Headquarter Detail Sale report is very slow

    Could you tell me which KB# FP2 should I download? could you send me if you have one?

  • Umar Khitab Profile Picture
    Umar Khitab 750 on at
    RE: MS RMS Headquarter Detail Sale report is very slow

    We are using database version RMS 2.05. Its working fine

    Thanks

    Umar

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: MS RMS Headquarter Detail Sale report is very slow

    RMS Ver - 2.0.1003

    Using MS SQL Server 2008 R2

  • Umar Khitab Profile Picture
    Umar Khitab 750 on at
    RE: MS RMS Headquarter Detail Sale report is very slow

    We had the same problem. We was not be able to open inventory transfer sheets quickly, reports got struck and was not be able to get the data, but after upgrading the RMS, It solve our all problems.

    Please share your database version.

    Thanks

    Umar

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: MS RMS Headquarter Detail Sale report is very slow

    That is not true. I am using SP4 with FP2 and it has not been solve my problem.

  • Verified answer
    Umar Khitab Profile Picture
    Umar Khitab 750 on at
    RE: MS RMS Headquarter Detail Sale report is very slow

    Dear All,

    We found the solution. Please just upgrade your RMS. Install SP4 and after that FP2. Your problem will be solve. No need to upgrade any server.

    Thanks

    Umar Khitab

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: MS RMS Headquarter Detail Sale report is very slow

    Our DB size is over 10GB and I reindex once a week. It works for a week and after week later it started goes really slow. I am not sure for the future, let say we are going to add more stores, that means, we are going to reindex DB more often. I think MS need to come up with some solution for this. Our server is pretty decent. I can't afford new additional server.

    My current Server specs.

    Windows Server 2008 R2 Standard

    Xeon X3430 @ 2.40GHz

    32GB Memory

    Dell PERC S100/S300 SCSI WD 7200RPM 250GB x 2

    New server specs.

    Windows Server 2998 R2 Enterprise

    Xeon X5650 @ 2.67GHz x 2 - 24 Cores

    72GB Memory

    Intel SSD 335 Series 240 x 2 with RAID 1

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,900 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,297 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans