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

Announcements

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 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,130

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

I have the same question (0)
  • ashlega Profile Picture
    ashlega 34,477 on at

    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)?

  • Alaa Ramadan Profile Picture
    Alaa Ramadan 4,130 on at

    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

  • Suggested answer
    PranavShroti Profile Picture
    PranavShroti 4,510 on at

    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

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

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 CRM (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans