Friday, February 10, 2017

Microsoft Dynamics CRM On-Premise Performance Testing

 

My colleague Eric Regnier has done some great work on CRM Performance Testing and would like to share what he shared with me….

For SQL Server indexing and tuning:

  1. Query Tuning: http://technet.microsoft.com/en-us/library/cc917579.aspx
  2. Understanding and resolving Microsoft SQL Server blocking: http://support.microsoft.com/kb/224453
  3. Optimizing Microsoft SQL Server Performance: http://support.microsoft.com/kb/110352/en-us
  4. SQL Server Clustered Indexing Best Practices: http://technet.microsoft.com/library/Cc917672
  5. Improving SQL Server Performance: http://msdn.microsoft.com/en-us/library/ff647793.aspx

CRM SDK call. i.e. when you do Data Migration jobs. Some of those might or might not increase perf:

  1. Leverage ExecuteTransactionRequest as much as possible for dependent records otherwise use ExecuteMultipleRequest
  2. Generate GUIDs of parent records within console instead letting CRM generate the GUIDs. This way will allow the script to create parent and child records in one transaction and reduce the complexity to O(n).
  3. Increase multiple request batch size to 2000 instead of 800. Requires PowerShell https://msdn.microsoft.com/en-us/library/gg334634.aspx. Should be put back to 1000 afterwards.
  4. Split console by entities. One Console per entity. I was able to achieve over 500000 per hour in a previous project with that way.
  5. Set the regarding field of the email once all emails were created in the system. 1st create emails then 2nd update Regarding
  6. Turn off database replication during DM

Network:

  1. Run the CRM Diag tool: <CRMUrl>/tools/diagnostics/diag.aspx

Web Server(s):

1. Only single Async CRM Server is running. Should be able to increase performance by having multiple async servers.

2. Enable the EnableRetrieveMultipleOptimization registry key

3. WCF Compression enabled

4. CRM SSL enabled

5. IIS Dynamic Compression is enabled

6. IIS system.web\caching\outputCaching omitVaryStar setting enabled (https://blogs.msdn.microsoft.com/crminthefield/2014/12/19/static-content-not-cached-properly-in-dynamics-crm-due-to-vary-header)

7. AsyncOperationBase is truncated/cleared?

8. Anti-virus excludes CRM or disabled

9. F5 load balancer compression enabled

CRM:

  1. Review Parental and Cascade All entity relationships settings for entities.
  2. Review the usage of Sharing. In custom workflow activities and plugins.
  3. Sharing with previous owner system setting off
  4. Disable workflow job retention logs from processes and plugins. This will help reduce the asyncoperation table.
  5. Review Business Rule scope configuration that are set to Entity. These will trigger at platform level.
  6. Review CRM traces and all frontend and backend servers:
    1. Sandbox logs and server level logs. Recommendation: Set at Errors only.
  7. Purge and review log configuration:
    1. Custom log entities and custom logs (e.g. NLog)
    2. Custom staging entities
    3. asyncoperation table
  8. Review audit settings. Only required entities and fields.
  9. Review Find Columns of Quick Find Views. Recommendation: max 10 fields per entities
  10. Review plugins on Retrieve if applicable
  11. Review form load performance with CRM Performance Center (CTRL+Shift+Q). Recommendation
    1. Tabs collapsed by default will increase load time
    2. No BPF. BPF take a lot of time to load
    3. Use subgrid when necessary and leverage associated grids in navigation instead.

Articles:

https://www.microsoft.com/en-au/download/details.aspx?id=27139

http://blog.craigharvey.me/2015/03/02/dynamics-crm-performance-troubleshooting/

https://blogs.msdn.microsoft.com/crminthefield/2011/06/09/principalobjectaccessperformance-recommendations/

https://blogs.msdn.microsoft.com/crminthefield/2014/07/14/using-performance-analyzer-for-microsoft-dynamics-dynamicsperf-in-a-development-test-or-qa-environment/ à https://dynamicsperf.codeplex.com/

http://blog.cobalt.net/blog/understanding-the-microsoft-dynamics-crm-performance-center

56 comments:

  1. this is really too useful and have more ideas from yours. keep sharing many techniques. eagerly waiting for your new blog and useful information. keep doing more.
    PTE Coaching in Chennai

    ReplyDelete
  2. Sindy, thank you for sharing Dynamics CRM performance resources and tuning tips, proposed by you and Eric. They are extremely helpful.

    Some performance issues appear on high concurrency levels, and their troubleshooting requires using a load testing tool. We developed one such tool called StresStimulus that captures user actions in a web browser and replays it to emulate and measure virtual users’ impact on performance. With this tool you can compare test results executed before and after implementing the performance tuning tips to see what works best for a particular scenario in your installation.

    ReplyDelete
  3. This is an awesome post.Really very informative and creative contents. These concept is a good way to enhance the knowledge.I like it and help me to development very well.Thank you for this brief explanation and very nice information.Well, got a good knowledge.
    Fresher Jobs
    Fresher Openings

    ReplyDelete
  4. Your posts about Microsoft Dynamics are amazing! It's very interesting! Please, continion your job, you are helping people who just start and also helping me :) For me it's just beginning how to use Microsoft Dynamics AX and it's exactly what I needed! dynamics ax - anegis consulting

    ReplyDelete
  5. I’m really amazed with your posting skills as well as with the layout on your blog site. Is this a paid style or did you modify it yourself? Either way keep up the pleasant quality writing, it is rare to see a great site such as this one these days.
    Office Interiors in Chennai
    Interior Decorators in Chennai

    ReplyDelete
  6. Nice blog post If you are searching for the qualityMicrosoft Dynamic Jobs than, DFSM Recruitment is known as the best Microsoft Dynamics Recruiter and recruit Microsoft Dynamics 365, CRM, SharePoint, Office 365 clients

    ReplyDelete
  7. you are posting a good information for people and keep maintain and give more update too.
    seo services india

    ReplyDelete
  8. Nice blogpost and thanks for sharing such useful information about Microsoft Dynamics.To get more best work opportunity in USA you should visit at Microsoft Dynamics 365 Recruitment.

    ReplyDelete
  9. Great blogpost and thanks for sharing such useful information about Microsoft Dynamics. If you are looking for the best Microsoft Dynamics Recruiters in USA then you should visit at Microsoft Dynamics jobs and recruitment.DFSM Recruitment provide various kinds of best Jobs hiring and Vacancies in the field of Microsoft Dynamics AX and CRM In USA.

    ReplyDelete
  10. Is there a reason to enable compression at both level (IIS and F5). Compressing an already compressed data is not going to be reduce payload size.

    ReplyDelete
  11. Your way of presenting the topic was exemplary. I like your article is nice.

    Selenium Training in Chennai

    ReplyDelete
  12. It has been just unfathomably liberal with you to give straightforwardly what precisely numerous people would've promoted for an eBook to wind up making some money for their end, basically given that you could have attempted it in the occasion you needed.

    Bigdata Training in Chennai

    ReplyDelete
  13. This blog is having the general information.Got a creative work and this is very different one.We have to develop our creativity mind.This blog helps for this. Thank you for this blog.This is very interesting and useful.

    Hadoop Training in Chennai

    ReplyDelete
  14. A great content and very much useful to the visitors. Looking for more updates in future.

    BIGDATA Training in Chennai

    ReplyDelete
  15. The Interior Designer is a plans, researches, coordinates, and manages the projects. Interior design is a multifaceted profession that includes conceptual development, space planning, site inspections, programming, research, communicating with the stakeholders of a project, construction management, and execution of the design.

    Interior Designers in OMR

    ReplyDelete
  16. Its really an Excellent post. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog. Thanks for sharing....

    Restaurant in OMR
    Apartments in OMR
    Villas in OMR
    Resorts in OMR

    ReplyDelete
  17. I read this blog it was really superb and excellent content I would like to say thanks to providing this for all of us. please share more content on msbi online training

    ReplyDelete
  18. I just asked microsoft partner, anegis consulting, to implement microsoft dynamics ax in my company. Everyone was slightly worried it would mess up our work for way too long, but it went much quicker than I supposed.
    Cheers :)

    ReplyDelete
  19. share this block .this block is very nice and attractive. customer-relationship-management.

    ReplyDelete
  20. All the latest updates from the Python Automationminds team. Python Automationminds lets you program in Python, in your browser. No need to install any software, just start coding straight away. There's a fully-functional web-based console and a programmer's text-editor
    Phyton training in Chennai

    ReplyDelete

  21. BIG DATA Technologies provides you with a state of the art software which combines modern GPU technology (Graphic Processing Units) with the best practices in today’s Big Data platforms, providing up to 100x faster insights from data.
    Bigdata Training in Chennai OMR

    ReplyDelete
  22. All the latest updates from the Python Automationminds team. Python Automationminds lets you program in Python, in your browser. No need to install any software, just start coding straight away. There's a fully-functional web-based console and a programmer's text-editor
    Phyton training in Chennai

    ReplyDelete
  23. Testers can build, enhance, and maintain scripts to regression test their mobile applications. Hands-on instruction is provided for those who want to explore the power of using Appium. The course covers content from installation to execution and reporting . The focus is on the practical application of Appium to resolve common mobile automated testing challenges. This course focuses on getting started with Appium.
    course/appiumtraininginsholinganallur/

    ReplyDelete
  24. Apply online for Microsoft Recruitment. Get the information about the current and upcoming vacancies here

    ReplyDelete
  25. As you have now understood the usage of ‘Record and Playback’ tool, the following are the different posts using which you can explore the functioning of ‘Selenium IDE’
    selenium Training in chennai

    ReplyDelete
  26. ok this is something cool i think.. love this post from all of your blogs man.. thank you so much..

    ReplyDelete
  27. All the latest updates from the PythonAutomationminds team. Python Automationminds lets you program in Python, in your browser. No need to install any software, just start coding straight away. There's a fully-functional web-based console and a programmer's text-editor
    Phyton training in Chennai

    ReplyDelete
  28. I’m planning to start my blog soon, but I’m a little lost on everything. Would you suggest starting with a free platform like Word Press or go for a paid option? There are so many choices out there that I’m completely confused. Any suggestions? Thanks a lot.
    Best AWS Training in Marathahalli | AWS Training in Marathahalli
    Amazon Web Services Training in Anna Nagar, Chennai |Best AWS Training in Anna Nagar, Chennai

    ReplyDelete
  29. Wow it is really wonderful and awesome thus it is very much useful for me to understand many concepts and helped me a lot. it is really explainable very well and i got more information from your blog.
    microsoft azure training in bangalore
    rpa interview questions and answers
    automation anywhere interview questions and answers
    blueprism interview questions and answers
    uipath interview questions and answers
    rpa training in bangalore

    ReplyDelete
  30. Really you have done great job,There are may person searching about that now they will find enough resources by your post
    Best Devops Training in pune
    Devops Training in Bangalore
    Power bi training in Chennai

    ReplyDelete
  31. You blog post is just completely quality and informative. Many new facts and information which I have not heard about before. Keep sharing more blog posts.
    python Course in Pune
    python Course institute in Chennai
    python Training institute in Bangalore

    ReplyDelete
  32. Wow !! Really a nice Article. Thank you so much for your efforts. Definitely, it will be helpful for others. I would like to follow your blog. Share more like this. Thanks Again.
    moto service center in chennai
    motorola service center in chennai
    moto service centre chennai
    moto service center
    motorola service center

    ReplyDelete
  33. This comment has been removed by the author.

    ReplyDelete
  34. It is really explainable very well and i got more information from your site.Very much useful for me to understand many concepts and helped me a lot.ServiceNow training in bangalore

    ReplyDelete
  35. Congratulations This is the great things. Thanks to giving the time to share such a nice information.best Mulesoft training in bangalore

    ReplyDelete
  36. The Information which you provided is very much useful for Agile Training Learners. Thank You for Sharing Valuable Information.Salesforce CRM Training in Bangalore

    ReplyDelete
  37. Excellent post for the people who really need information for this technology.ServiceNow training in bangalore

    ReplyDelete
  38. Very useful and information content has been shared out here, Thanks for sharing it.Mulesoft training in bangalore

    ReplyDelete
  39. Awesome post with lots of data and I have bookmarked this page for my reference. Share more ideas frequently.salesforce crm training in bangalore

    ReplyDelete
  40. Thank you for the most informative article from you to benefit people like me.Salesforce Admin Training in Bangalore

    ReplyDelete
  41. Your articles really impressed for me,because of all information so nice.devops Training in Bangalore

    ReplyDelete
  42. These provided information was really so nice,thanks for giving that post and the more skills to develop after refer that post.Amazon web services Training in Bangalore

    ReplyDelete
  43. I gathered a lot of information through this article.Every example is easy to undestandable and explaining the logic easily.python training in bangalore

    ReplyDelete
  44. Very useful and information content has been shared out here, Thanks for sharing it.selenium training in bangalore

    ReplyDelete
  45. This is really an awesome post, thanks for it. Keep adding more information to this.mulesoft training in bangalore

    ReplyDelete
  46. I am obliged to you for sharing this piece of statistics
    here and updating us together with your inventive steerage.
    sd movies point
    ............................................................

    ReplyDelete
  47. You have made some really good points there. I looked on the web for more info about the issue and found most people will go along with your views on this site.
    Techno

    ReplyDelete
  48. I'M NOW FULFILL FINANCIALLY BECAUSE OF THE LOAN I GOT FROM LFDS .I would like to bring this to the notice of the public about how i came in contact with LFDS after i lost my job and being denied loan by my bank and other financial institution due to my credit score. I could not pay my children's fees. I was behind on bills, about to be thrown out of the house due to my inability to pay my rent, It was during this period my kids were taken from me by foster care. Then i set out to seek for funds online where i lost $3,670 that i borrowed from friends which i was rip off by two online loan companies. Until i read about:Le_Meridian Funding Service  (lfdsloans@outlook.com / lfdsloans@lemeridianfds.com) somewhere on the internet, Still wasn't convince because of what i have been through until a relative of mine who is a clergy also told me about the ongoing loan scheme of LFDS at a very low interest rate of 1.9%% and lovely repayment terms without penalty for default of payment. I have no choice than to also contact them which i did through text +1-989-394-3740 and Mr Benjamin responded back to me That day was the I'M best and greatest day of my life which can never be forgotten when i receive a credit alert of $400,000.00 Usd loan amount i applied for. I utilized the loan effectively to pay up my debts and to start up a business and today i and my kids are so happy and fulfill. You can as well contact them through email: (lfdsloans@outlook.com / lfdsloans@lemeridianfds.com)  WhatsApptext  helpline: +1-989-394-3740 Why am i doing this? I am doing this to save as many that are in need of a loan not to be victim of scams on the internet. Thanks and God bless you all, I'm Oleksander Artem from Horizon Park BC , Ukrain.

    ReplyDelete