SharePoint 2019 SQL sizing

MSaeed 21 Reputation points
2020-09-10T09:51:56.613+00:00

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://video2.skills-academy.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.

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,373 questions
SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,961 questions
0 comments
Accepted answer
  1. Trevor Seward 11,706 Reputation points
    2020-09-10T15:38:51.213+00:00

    200GB isn't a limitation, you can grow much higher than that into the TB range.

    Memory sizing isn't an exact science, it depends on a variety of factors, including usage. What I would suggest is you start at 64GB RAM for your SQL Server and size up from there as necessary, monitoring SQL performance counters.

    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. MSaeed 21 Reputation points
    2020-09-14T08:46:12.497+00:00

    Thank you for your input. This is what i will be doing

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.