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

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GP reports running slo...
Microsoft Dynamics GP (Archived)

GP reports running slow sporadically during certain times in a day

(0) ShareShare
ReportReport
Posted on by Community Member

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.

*This post is locked for comments

I have the same question (0)
  • Tami Farrelly Profile Picture
    Tami Farrelly 5,080 on at

    Sounds like it maybe a network issue??

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    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.

  • MG-16101311-0 Profile Picture
    MG-16101311-0 26,225 on at

    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.

  • Community Member Profile Picture
    Community Member on at

    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

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

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans