SharePoint 2019 SQL sizing

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://learn.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.

Answer 1

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.

Answer 2

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