Turn off Microsoft CRM 2011 5000 limit

David Finley — Tue, 18 Oct 2011 13:17:33 GMT

KBA-01121-C7T9Q0

Purpose & Scope

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.

Procedure

On the server running CRM

Click Start, click Run, type regedit in the Open box, and then click OK.
Locate and then select the following registry subkey:
HKEY_LOCAL_MACHINE\Software\Microsoft\MSCRM
On the Edit menu, point to New, and then click DWORD Value.
Type TurnOffFetchThrottling, and then press ENTER.
Right-click TurnOffFetchThrottling, and then click Modify.
Type a number other than 0 in the Value data box, and then click OK.

Note Step 6 lets you retrieve the number of records specified in the Count attribute of your fetch statement.
On the File menu, click Exit.

Additional Comments

http://www.interactivewebs.com/blog/index.php/server-tips/turn-off-microsoft-crm-2011-5000-limit-on-data-retrieval-via-sdk/

CRM 2011 XRM Performance Problem IIS Dynamic Compression

David Finley — Tue, 18 Oct 2011 13:18:59 GMT

CRM 2011 XRM Performance Problem IIS Dynamic Compression

KBA-01122-C8M3Z5

Purpose & Scope

Microsoft CRM 2011 allows XRM services that use application/soap+xml content type.

When you install Microsoft CRM 2011 in an IFD / hosted environment, it is smart enough to automatically configure IIS gzip compression on the website.

What it does not do, is configure the

C:\Windows\System32\Inetsrv\Config\applicationHost.config

file to compress XRM calls out of the CRM database.

In a test we were performing for an update to our Microsoft CRM 2011 Portal technology, we found that retrieving a list of around 20,000 items returned a 19 MB data package without gzip dynamic compression. Not huge but pretty big! What amazed us was that after enabling dynamic compression on the XRM data, this reduced from 19 MB to 890 KB, a huge performance improvement!

We also noticed that the Microsoft Hosted CRM 2011 service already has this compression enabled, so we figured if it is good enough for them, then we should give it a shot.

Procedure

How to Enable XRM gzip Compression in IIS

Navigate to: C:\Windows\System32\Inetsrv\Config\applicationHost.config

and open it in your favourite editor.

Search for the Section: “<httpCompression directory=”

And in that section you will probably find an entry that looks like this:

<add mimeType='application/x-javascript' enabled='true' />

Below that, add the following:

<add mimeType='application/soap+xml' enabled='true' />

So the file looks like this:

Note: We are making the assumption that you are on Windows 2008, and that CRM 2011 was successfully installed, and that this in turn enabled IIS compression on the Microsoft CRM website.

These steps should massively improve data access to CRM using XRM calls.

Additional Comments

http://www.interactivewebs.com/blog/index.php/server-tips/crm-2011-xrm-performance-problem-iis-dynamic-compression/

InteractiveWebs

Turn off Microsoft CRM 2011 5000 limit

CRM 2011 XRM Performance Problem IIS Dynamic Compression

How to Enable XRM gzip Compression in IIS