locked
CRM 2011: Speed RRS feed

  • Question

  • Seems like our CRM is starting to slow down a little. Example of one of the things that is happening is our views sometime take 45 seconds to open. What can we do/check to make the speed of CRM work faster.

    Thanks in advance.

    Wednesday, May 13, 2015 3:56 PM

All replies

  • For the views, try limiting the number of columns that return option set/pick list data because these require additional overhead when the data is returned.  I'm assuming that lookup fields suffer the same issue.  If possible, stick with views that return actual text fields since these don't have to be cross referenced with another table for each field on the entity.

    Install the most recent rollup for CRM.

    Check custom indexing.  Sometimes a DBA will add custom indexing to improve performance because that's what they normally do.  But over indexing can be detrimental to CRM performance.  And it is easy to do.  The most recent versions of CRM handle indexing pretty good and don't require anyone to manually tweak it.

    You may also want to look at the size of your database and what tables are the largest.  Are these the ones with poor performance for the views?  Such as Activities?  Or is the Async base table full of completed workflows?  Workflows can now be set to delete themselves when they complete (and have been able to do so since CRM 2011).  If you have an older version of CRM, you may need to run a script to clear out those old completed workflows.

    You may also want to look at the hardware to make sure it meets a little more than the basic requirements.  Sometimes customers will set up with the bare minimum when it comes to CPU speed and RAM.

    You can look at turning on compression in IIS for the CRM server to reduce latency.

    There is an add in for Visual Studio that will allow you to do performance testing on the server.  This lets you test specific entities and input test data using a predetermined number of ghost users.  The statistics returned can help determine where the issue is.

    In short, there are a number of things that can be done.  You will really need to analyze the system to determine what is causing the issue.  There isn't one singe cure all because of the complexity of the system.


    Jason Peterson

    Wednesday, May 13, 2015 4:15 PM
  • Thank you Jason. Is there a tool that we can use to analyze the CRM System?
    Wednesday, May 13, 2015 4:22 PM
  • Start here.  There is a link at the bottom that provides more detailed information on the performance analyzer.

    http://blogs.msdn.com/b/axinthefield/archive/2014/06/05/using-performance-analyzer-for-microsoft-dynamics-in-a-development-test-or-qa-environment.aspx


    Jason Peterson

    Wednesday, May 13, 2015 9:45 PM