Turn off Microsoft CRM 2011 5000 limit on data retrieval via SDK

With CRM 4.0 and Microsoft CRM 2011 there is a default limit for the number items that can be retrieved when making various types of web service calls into the CRM.

Typically this limit is set to 5000 but with some types of calls it will return 7000. In any case, the process to remove the limit and set it to 20,000 is very easy.

On the server running CRM

  1. Click Start, click Run, type regedit in the Open box, and then click OK.
  2. Locate and then select the following registry subkey:HKEY_LOCAL_MACHINE\Software\Microsoft\MSCRM
  3. On the Edit menu, point to New, and then click DWORD Value.
    image
  4. Type TurnOffFetchThrottling, and then press ENTER.
    image
  5. Right-click TurnOffFetchThrottling, and then click Modify.
    image
  6. Type a number other than 0 in the Value data box, and then click OK.
    imageimage
    Note Step 6 lets you retrieve the number of records specified in the Count attribute of your fetch statement.
  7. On the File menu, click Exit.
    image

About InteractiveWebs

This blog is the combined blog work of the InteractiveWebs Dev Team. Together we work on a range of DotNetNuke (DNN) applications, modules, Silverlight, and Microsoft CRM Portal integration products.

Our Business is website design and hosting, with a strong focus on DotNetNuke, Microsoft Dynamics CRM, Silverlight and iPhone iPad development.

Tagged . Bookmark the permalink.

17 Responses to Turn off Microsoft CRM 2011 5000 limit on data retrieval via SDK

  1. Pingback: CRM 2011 – 5000 record limit on data retrieval via SDK « Hosk's Dynamic CRM 2011 Blog

  2. Mziyabo says:

    You just saved me from writing some unneccesary code bru thanks

  3. Pingback: CRM 2011 views: getting more than 5000 records « MayankP's Blog

  4. Pingback: Límites de tiempo y otros límites de CRM 2011 | El Blog CRM

  5. Pingback: Microsoft CRM 2011 Timeouts and Limits - Yaniv Arditi

  6. Pingback: CRM2011 and C# : Avoiding the 5000 records limitation. Paging Retrieve Multiple Results. | hachecrm2011

  7. Pingback: Microsoft CRM 2011 Tiempos de espera y límites - El blog de Rafa Ansino en Geeks.ms - Geeks•ms

  8. Pingback: CRM 2011 Timeouts and Limits « Marcello Tonarelli Blog

  9. kreed says:

    This is causing an error on CRM 2011 UR11: http://support.microsoft.com/kb/2748933

  10. Peter says:

    Hi,

    Very interesting so how to do it with crm online.??

    EntityCollection list_contacts = service.RetrieveMultiple(new FetchExpression(fecthContactsActifs));

    5000 ONLY RETRIEVED while i got more

    Thank u for you answer.;;;???

  11. Suraj kumbhar says:

    What if i want to do this for a single entity in MSCRM 2013

  12. Suraj kumbhar says:

    Hi

    Please let me know will this effect to Quick Find view

    Thank you in advance.

    Suraj

Leave a Reply

Your email address will not be published. Required fields are marked *