Dynamics CRM in the Field

Information from the Microsoft Dynamics CRM PFE team working in the field

Performance Analyzer for Microsoft Dynamics

Performance Analyzer for Microsoft Dynamics

Rate This
  • Comments 2

I wanted to make sure everyone is aware of a really great tool that can be used to measure and improve performance of Dynamics CRM based on the SQL Server.  I recently used the tool for a Performance Review service and it worked really well.  The tool is now publically available.  Version 1.0 of the tool includes scripts specific to Dynamics AX.  However many of the scripts in the tool work just fine for Dynamics CRM as well and can provide some great information on SQL Server performance.  The Perf Analyzer tool has been blogged about over on the “AX in the Field” blog but wanted to get the word out here too because it can be just as applicable to CRM.

I would suggest a good working knowledge of SQL Server before using this tool, as the tool is made up of a series of SQL scripts.  But there are also very good step-by-step instructions on deploying and using the tool as well.  Scripts are available in the tool to investigate SQL configuration, identify expensive queries, investigate indexes, list index activity for a certain table, and capture and investigate blocking to name a few things.

For CRM specifically, when custom attributes/fields/entities are created, indexes may not be optimized on the base and extension tables for theses entities.  The Perf Analyzer tool can help identify where these might be leading to long-running queries and point you in the right direction of tuning the queries appropriately.

See the following links for further info on the tool and to download and start using it.  Once you get it downloaded, unzip it and look for the “Performance Analyzer 1.0 for Microsoft Dynamics Install Guide.pdf” file for info on getting up and running.

  • "For CRM specifically, when custom attributes/fields/entities are created, indexes may not be optimized on the base and extension tables for theses entities.  The Perf Analyzer tool can help identify where these might be leading to long-running queries and point you in the right direction of tuning the queries appropriately."

    Are custom attributes indexed at all in CRM 2011? More pertinently, how about in CRM Online? If they are not indexed (as I suspect), I imagine that this tool is of no use for CRM Online users.

  • The link for Dynamicsperf doesnt work.Is it moved to a different location?? What are the updates for CRM2013.

Page 1 of 1 (2 items)
Leave a Comment
  • Please add 7 and 4 and type the answer here:
  • Post