Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Answered

Regarding Dynamics CRM On Premise database sizing

(0) ShareShare
ReportReport
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

News and Announcements

Announcing Category Subscriptions!

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans