Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Maximum Number of Records in an Entity

Posted on by 225

Hello,

What is the maximum number of records in an entity, is there a CRM limitation or is the man number based on SQL?

I plan on importing 250K records in a custom entity, things are working great with my 100K+ records so far. This entity will primary be used for archiving and only accessed for by custom reports. 

I am aware of limitations when using charts or exporting to Excel and this does not affect me. 

*This post is locked for comments

  • Suggested answer
    Mahendar Pal Profile Picture
    Mahendar Pal 45,095 on at
    RE: Maximum Number of Records in an Entity

    Hi,

    You will see slowness in application use when your db size will be reaching near to the limit, and Microsoft will send you notification to buy more space, further you can request them which specific table has increased .

  • Verified answer
    RaviKashyap Profile Picture
    RaviKashyap 55,410 on at
    RE: Maximum Number of Records in an Entity

    Hi Jerry,

    For CRM online, you don't get the direct access to see the database but you can use org insights to see top table consuming most of the database. You can also contact Microsoft and they can share you the complete list of table with rows and size.

    docs.microsoft.com/.../use-organization-insights-solution-view-instance-metrics

    appsource.microsoft.com/.../mscrm.04931187-431c-415d-8777-f7f482ba8095

    Also, Microsoft monitor the database and once you reach near to you rlimit, they will start sending notification to purchase more space.

    Hope this helps.

  • Jerry P. Profile Picture
    Jerry P. 225 on at
    RE: Maximum Number of Records in an Entity

    This is helpful. Another question.

    What do I need access too to see how big my db is? Will MS monitor this and resize if needed? At a cost obviously.

  • Suggested answer
    gdas Profile Picture
    gdas 50,085 on at
    RE: Maximum Number of Records in an Entity

    Hi Jerry,

    There is no limit in Dynamics CRM database as its depends on database space which you have in your current online instance and you can buy more space if you want.

    Hope this helps

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans