locked
CRM freezing at basic navigations RRS feed

  • Question

  • Hi all,

    My CRM implementation is freezing or slow at times for some users at random ,we are using crm 4.0 and clients has the IE 7 on their desktops,we are using web client, 

    we tried every thing monitoring Memory usage and CPU usage on desktop and on servers, only CRM application hangs and if closed and reopened works normal , this is very wierd to figure,

    if any of you guys faced such sort of issue, kindly provide me the solution which might help me 

    THanks in advance 

    Regards,

    Anil 


    kumar

    Tuesday, October 23, 2012 6:07 PM

All replies

  • Hi Anil,

    Mostly the CRM performance issues like denial of service or slow running application would be because of SQL Server. When you said "we tried every thing monitoring Memory usage and CPU usage on desktop and on servers", I am assuming apart from CRM application server, you have also checked the SQL Server. If not, then whenever someone complains of the slow CRM, immediately check the SQl Server machine for memory.

    In my experience mostly the culprit is SQL Server (but the reason leading to slow SQL Server could be many).

    One reason could be dynamic excel worksheets. There is a feature in CRM where your users can save data not as static excel worksheets, but as dynamic excel worksheets. What this does is embed the connection to CRM Server inside the excel file which is on the users local computer. Whenever the user opens this kind of excel file, the file will first refresh and bring back refreshed data from CRM Server. Now if the user has created this excel sheet from an entity having thousands of records, this will slow down your CRM and even make it unavailable to your users. This is because SQl Server starts running slow which you can see on your SQL Box (the memory max out).

    The other issue could be hanging workflows. Your CRM might have many workflows and workflows might be hanging or in wait state, due to some issue. Check your system jobs to see whether that is the case.

    The other reason could be the entity form has so many JScripts embedded (many customizations) in it, and these JScripts are connecting back to your CRM Server through AJAX to fetch the data. So after opening any record, CRM slows down on your user's machine.

    The other area of investigation is Reports. If your CRM slows down after opening particular reports, then the issue is the SQL written in the reports. In that case re-factor the SQL scripts in these reports.

    Try running SQL Profiler against your CRM organisation database. This will show slow running queries. Turn on SQL Profiler whenever your CRM is slow as SQL Profiler will further slow your CRM.

    Enable trace in CRM. Tracing will always give insight of what went wrong and where. Enable tracing only when there is an issue with your CRM. Enable for few minutes and check your logs.

    My advice would be to check your CRM as soon as someone reports that CRM is working slowly. Go to that user's machine and see exactly what he was doing at that time. If he opened an entity record, or a report or a CRM connected excel file or simply doing advanced find on thousands of records. Then you can concentrate your energy in that area to find the reason.

    I hope this helps. If my response answered your question, please mark the response as an answer and also vote as helpful.


    Ashish Mahajan, Microsoft Dynamics CRM Solutions Architect, CSG (Melbourne)
    My Personal Website: http://www.ashishmahajan.com
    My Blogs: http://ashishmahajancrm.blogspot.com.au and http://ashishmahajancrm.wordpress.com
    My Youtube Channel: http://www.youtube.com/user/ashishmahajanmscrm

    My Linkedin: View Ashish Mahajan's profile on LinkedIn
    My Twitter: https://twitter.com/#!/ashishmahajan74


    Wednesday, October 24, 2012 1:07 AM
  • Thanks a lot Ashish, i have looked all the points suggested by you, the one i missed out is Dynamic Excel, i will try to find this if any one is using at the time when the application is slow 


    kumar

    Wednesday, October 24, 2012 2:03 PM
  • Hi Kumar,

    If the response answered your question and you are satisfied, please mark the response as an answer. This will help others to search on similar problems.

    Thanks in advance.

    Ashish Mahajan, Microsoft Dynamics CRM Solutions Architect, CSG (Melbourne)
    My Personal Website: http://www.ashishmahajan.com
    My Blogs: http://ashishmahajancrm.blogspot.com.au and http://ashishmahajancrm.wordpress.com
    My Youtube Channel: http://www.youtube.com/user/ashishmahajanmscrm

    My Linkedin: View Ashish Mahajan's profile on LinkedIn
    My Twitter: https://twitter.com/#!/ashishmahajan74

    Thursday, November 15, 2012 4:45 AM
  • Hi AnilKumar,

    I think Ashish is correct in suggesting this is a possible SQL performance issue. Check the below article for tuning your SQL CRM database

    http://quantusdynamics.blogspot.co.uk/2012/11/dynamics-crm-database-optimization-with.html

    Hope this helps.


    Visit my blog for CRM material, improving performance, kerberos, IFD, development tips, etc. :) http://quantusdynamics.blogspot.com

    Monday, November 19, 2012 9:14 AM
    Answerer