Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Slow Contact Form Load...
Microsoft Dynamics CRM (Archived)

Slow Contact Form Load in CRM 2016

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

For couple of users in the company, the Contact loads really slow, takes about 20-30 seconds in an on-premise CRM 2016. There are no javascripts on form load and I removed all the subgrids from the form without any success. I also had them use other computers. Below are the stats from the Performance Center (starts taking more time form Data Ready), but I cannot find any more information on how to read it. What else can I check/do to fix the issue? Again, it's only happening to only a couple of people.

Form Load Start (-> 0 ms)
CommandBar Rendered (-> 29 ms)
Load Content Start (-> 29 ms)
Turbo Form Load Start (-> 157 ms)
Custom Script Frame Loaded (-> 326 ms)
Turbo.ActivityFeeds_Start (-> 410 ms)
LoadActivities_Start (-> 412 ms)
LoadNotes_Start (-> 412 ms)
NoteshRefreshEvent_Start (-> 420 ms)
Wall_RefreshAll_Start (-> 436 ms)
Page Ready for Data Bind (-> 459 ms)
Wall_RefreshAll_End (-> 612 ms)
Data Ready (-> 17172 ms)
PageLoadedWithRibbonData (-> 17280 ms)
TurboFormPreOnloadTimestamp (-> 17283 ms)
TurboFormPostOnloadTimestamp (-> 17283 ms)
MDDEnd (-> 17283 ms)
CommandBar Rendered (-> 17439 ms)
ControlsInitializationCompleteTimestamp (-> 17440 ms)
AllSubgridsLoaded (-> 17528 ms)

Thank You,

Mehul

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Slow Contact Form Load in CRM 2016

    For anyone else having the issue, we fixed it by running the following queries in SSMS. Please make sure the user is not using CRM while performing these steps. 

    1. Get the user id in CRM
      select FullName, SystemUserId from SystemUser order by FullName
    2. Then update the RecentlyViewedXml column to a blank string in UserEntityUISettingsBase table for the Contact entity

      update UserEntityUISettingsBase
      set RecentlyViewedXml = ''
      where OwnerId = '<id of the contact having the issue from step 1>'
      and ObjectTypeCode = 2  --contact entity type

    I tried setting RecentlyViewedXml to NULL, but that didn't work, CRM kept updating the field with the original string.

    Thanks,

    Mehul

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Slow Contact Form Load in CRM 2016

    Hi Mansoor, I'll check with our cloud provider to see if they can even put the DB on the physical drive.

    Thanks,

    Mehul

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Slow Contact Form Load in CRM 2016

    Hi Guillaume, yes, it's always slow. And it's always the Contact form, all other records load ok.

    Thanks,

    Mehul

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Slow Contact Form Load in CRM 2016

    Hi, we use the default contactids assigned by CRM. We tried rebuilding the indexes but that didn't fix it. I'll try to use the SQL Profiler to see if that helps. Also, this happens to only a couple of users. If it was SQL I'd think everyone should have the same issue.

    Thanks,

    Mehul

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Slow Contact Form Load in CRM 2016

    Hi,

    We had the same issue. You can refer below link which I opened a thread in this forum quite a time before.

    community.dynamics.com/.../178625

    Hope it helps you.

    Mansoor

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Slow Contact Form Load in CRM 2016

    Hi,

    is it always the case? The 1st loading is always slower. If you reload the record, what time do you get?

  • Emre GULCAN Profile Picture
    Emre GULCAN 2,379 on at
    RE: Slow Contact Form Load in CRM 2016

    Hi,

    Performance issues are depend on many reasons.You say did some fixes on clientside (CRM forms), I think you should check your database performance and queries with SQL Profiler. Not sure but if you set your contact ID (contactid) data manually with SDK probably it's main reason. Also you can check database indexes

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Slow Contact Form Load in CRM 2016

    For couple of users in the company, the Contact loads really slow, takes about 20-30 seconds in an on-premise CRM 2016. There are no javascripts on form load and I removed all the subgrids from the form without any success. I also had them use other computers. Below are the stats from the Performance Center (starts taking more time form Data Ready), but I cannot find any more information on how to read it. What else can I check/do to fix the issue? Again, it's only happening to only a couple of people.

    Form Load Start (-> 0 ms)
    CommandBar Rendered (-> 29 ms)
    Load Content Start (-> 29 ms)
    Turbo Form Load Start (-> 157 ms)
    Custom Script Frame Loaded (-> 326 ms)
    Turbo.ActivityFeeds_Start (-> 410 ms)
    LoadActivities_Start (-> 412 ms)
    LoadNotes_Start (-> 412 ms)
    NoteshRefreshEvent_Start (-> 420 ms)
    Wall_RefreshAll_Start (-> 436 ms)
    Page Ready for Data Bind (-> 459 ms)
    Wall_RefreshAll_End (-> 612 ms)
    Data Ready (-> 17172 ms)
    PageLoadedWithRibbonData (-> 17280 ms)
    TurboFormPreOnloadTimestamp (-> 17283 ms)
    TurboFormPostOnloadTimestamp (-> 17283 ms)
    MDDEnd (-> 17283 ms)
    CommandBar Rendered (-> 17439 ms)
    ControlsInitializationCompleteTimestamp (-> 17440 ms)
    AllSubgridsLoaded (-> 17528 ms)

    Thank You,

    Mehul

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans