none
SharePoint 2019 SQL capacity planning RRS feed

  • Question

  • Hello,

    I am migrating my company's file server to SharePoint 2019. The total combined data size is 20 TB.

    I am aware of the DB limitations (keeping them at 200 GB each) and accordingly i will distribute the data per database per department.

    As per MS article https://docs.microsoft.com/en-us/sharepoint/administration/storage-and-sql-server-capacity-planning-and-configuration#estimate-memory-requirements, 

    Combined size of content databases RAM recommended for computer running SQL Server
    Minimum for small production deployments
    8 GB
    Minimum for medium production deployments
    16 GB
    Recommendation for up to 2 terabytes
    32 GB
    Recommendation for the range of 2 terabytes to 5 terabytes
    64 GB
    Recommendation for more than 5 terabytes
    Additional RAM over 64 GB can improve SQL Server caching speed

    Now the size of our combined DB is well over 5 TB (20 TB), the recommendation here is not clear on how much RAM is required for the SQL server.  What is recommended RAM for SQL hosting 20 TB of combined content DBs.

    I would also like to add that we are using Remote Blob Storage.

    Thursday, September 10, 2020 9:50 AM