Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Performance issues wit...
Microsoft Dynamics GP (Archived)

Performance issues with Business Analyzer, SSRS and GP 2013

(0) ShareShare
ReportReport
Posted on by Tracey01 225

Anyone else having these issues and if so, were you able to resolve?

SSRS and BA taking up all the resources.

After some significant investigation we believe that the issues we’re experiencing related to performance are directly connected to certain reports loaded automatically by Business Analyzer. We have been able to isolate a number of reports that instantly cause the server to become maxed out – many of the reports provide no opportunity to apply any form of filter and therefore attempt to load the entire data set at once. Other reports that do not load the entire data set work as anticipated.

 

We have taken a number of steps to simulate the issue in an alternate SQL environment and have experienced the same issue.

*This post is locked for comments

  • Tracey01 Profile Picture
    Tracey01 225 on at
    RE: Performance issues with Business Analyzer, SSRS and GP 2013

    Hi Liz - please email me at tracey.Santos@encorebusiness.com and I will email you the instructions

  • erowden Profile Picture
    erowden 727 on at
    RE: Performance issues with Business Analyzer, SSRS and GP 2013

    How do you go about removing these deployed reports from GP 2013?

  • Verified answer
    Tracey01 Profile Picture
    Tracey01 225 on at
    RE: Performance issues with Business Analyzer, SSRS and GP 2013

    thank you for that info, we were just going to remove it altogether to see how much improvement was gained.

  • Tracey01 Profile Picture
    Tracey01 225 on at
    RE: Performance issues with Business Analyzer, SSRS and GP 2013

    yes

  • Rob Bernhardt Profile Picture
    Rob Bernhardt on at
    RE: Performance issues with Business Analyzer, SSRS and GP 2013

    Tracey,

    The reports that are intended for the Business Analyzer don't require any parameters to be set.  They can run on default parameters.  If you have a large amount of data, they could certainly be slow for you.  

    If certain reports are causing performance issues, they can be removed or modified to better suit your needs.  Keep in mind that newer versions of GP will likely replace any changes you have made.

    Thanks

    Rob

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Performance issues with Business Analyzer, SSRS and GP 2013

    Are you running SRSS and SQL on the same server?  

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans