CODEWITHSUNDEEP
dynamics-crmdynamics-crm-2016
asolovyov
asolovyov

Reputation: 963

Does Microsoft Dynamics CRM 2016 has records count limitations

I've researched MSDN documentation for Microsoft Dynamics CRM 2016 Requirements and Conditions and did not find any information about records count limitations.

How many records can I store in CRM entity lists and what're best practices about storing of large count of items (more than 1M records)?

I'm using CRM REST services to process some of data on the portal. So, how big size of target list can have influence on perfomance of select queries?

Upvotes: 1

Views: 434

Answers (1)

pen2
pen2

Reputation: 769

Under CRM is MSSQL database so in most cases you can diagnose data performance problems with SQL tools (Dynamic Management Views or SQL Profiler) In company that I work for we have few entities with over 8M records and things are running smooth. We had to add a few indexes (without them some of our queries were running slow) also document Optimizing and Maintaining a Microsoft Dynamics CRM 2011 Server Infrastructure was much help - even if it is for 2011 version many things are accurate for 2016.

Upvotes: 2

Related Questions