Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Unanswered

GP reports running slow sporadically during certain times in a day

Posted on by Microsoft Employee

We've been seeing performance dips when running GP reports during specific times in the day usually around 9:30a and 11:00a but then post that it disappears. As per the CFO the report itself doesn't have any issues but when they drill down to user accounts it goes slow. Any reason as to why this would be the case when there is no resource crunch on the server during those times and there is nothing going bad really. I can get more details on exactly what is the version and what kind of report they are running so let me know what is needed in order to figure out this issue and I can speak to the CFO and gather more details.

Categories:
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GP reports running slow sporadically during certain times in a day

    I've reached out to the client but haven't got back any updates yet to share. However, as soon as I have something I will relay it here.

    Thanks

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: GP reports running slow sporadically during certain times in a day

    What types of reports are you talking about? SSRS reports, Report Writer reports? Excel reports? I've troubleshot a number of SSRS and Excel reports that query extensive data without applying the WITH (NOLOCK) clause in the SQL queries. This tends to create contention and deadlock between processes like posting and the report generation itself - especially in poorly implemented SQL Server environment. As for Report Writer reports, those typically build data and display it on a record by record basis. The larger the data set, the slower the report.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: GP reports running slow sporadically during certain times in a day

    Any historical aged trial balance report will take a long time and even longer as the volume of data grows. Let us know which reports are running slowly and we can be more specific.

  • Tami Farrelly Profile Picture
    Tami Farrelly 5,080 on at
    RE: GP reports running slow sporadically during certain times in a day

    Sounds like it maybe a network issue??

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans