Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Different users experi...
Microsoft Dynamics CRM (Archived)

Different users experience different performance in CRM

(0) ShareShare
ReportReport
Posted on by Alaa Ramadan 4,090

Hi All,

I have a weird performance issue with CRM, different users experience different performance from the same office/organization/network while open/reply or forward to email

User A  - poor performance

User B - reasonable performance

I asked user A to login to CRM from user B machine - the result is the same for user A, same performance issue

Something related to user A profile

I replaced user A profile in CRM and then recreated, removed his security roles and re-added, no difference

The only thing I can tell is that user A has been working in CRM for longer time say 5 years, user B has one year only in CRM

Does this give any clue?

I'm pretty sure the issue is more related with the data belong to that user who has performance  issue. 

Appreciate any help or clue.

Thank you,

 

 

 

*This post is locked for comments

  • Suggested answer
    PranavShroti Profile Picture
    PranavShroti 4,510 on at
    RE: Different users experience different performance in CRM

    Hi, As Alex suggested your POA table needs to be cleaned, this link might help

    community.dynamics.com/.../232824

    Additionally you can think of record purging, so the records no longer required in CRM could be moved to a different database and can be produced ondemand (if required).

    Regards,

    Pranav

    If you found the answer helpful, please mark as Verified

  • Alaa Ramadan Profile Picture
    Alaa Ramadan 4,090 on at
    RE: Different users experience different performance in CRM

    Hi Alex,

    I ran the following statement from SQL

    SELECT ObjectTypeCode, COUNT(ObjectTypeCode) AS Total

    FROM PrincipalObjectAccess

    GROUP BY ObjectTypeCode

    ORDER BY Total DESC

    Here are is the result below. Is it normal for the ActivityPointer to have 5M records in PrincipalObjectAccess table?

    ObjectTypeCode      Total

    4200                           5127913

    112                             254370

    5                                 9050

    2                                 397

    8                                 131

    150                            131

    9100                          115

    2010                          75

    9106                          30

    1031                          12

    1112                          2

    1                                 2

    4230                          2

  • ashlega Profile Picture
    ashlega 34,477 on at
    RE: Different users experience different performance in CRM

    Hi,

     maybe there are records shared with that user, so it's possible that those shared records are slowing down the SQL queries (where Dynamics is doing security checks)

     Are you using sharing or, maybe, access teams(though access teams should be less of a problem)?

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

Announcing Our 2025 Season 1 Super Users!

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

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans