Skip to main content

Notifications

Microsoft Dynamics CRM forum
Answered

Regarding Dynamics CRM On Premise database sizing

Posted on by 5

Hi there,

I am a CRM new player, and have a question is about SQL database sizing. I wondered if there is any way to estimate the requirements for your database, anticipate capacity for growth, and plan disk requirements without any mail or files. because I will use SharePoint to storage my files and email.

Thanks

  • Verified answer
    Ken Hubbard Profile Picture
    Ken Hubbard on at
    RE: Regarding Dynamics CRM On Premise database sizing

    Hello,

    Thanks for using the communities.

    The On Premise version of Dynamics CRM does not have any built in tooling to monitor and report against database size and table sizes. For this, I would recommend looking into something that can report against table size growth and database growth from a SQL perspective.  For instance, the following is an example of using SSRS to capture table growth:

    www.mssqltips.com/.../

    I am sure there are other ways to get about this as well, but I believe all of those approaches would be from the SQL side.

    Thanks,

    Ken Hubbard

    Microsoft Dynamics Support

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,469 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans