question

Vishu-2318 avatar image
0 Votes"
Vishu-2318 asked AmeliaGu-msft commented

Core Vs RAM

For a physical server , is there a recommended value for SQL that if 16 cores the server memory should be 128 GB etc

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Vishu-2318,
Did the answers help you?
Please feel free to let us know if you have any other question.
If you find any post in the thread is helpful, you could kindly accept it as answer.

Best Regards,
Amelia

0 Votes 0 ·
AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

Hi Vishu-2318,
Agree with others.
For SQL Server memory value, please refer to How Much Memory is “Normal” for SQL Servers which might help.

Best Regards,
Amelia


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

TomPhillips-1744 avatar image
0 Votes"
TomPhillips-1744 answered

There is no relationship between CPU core count and RAM size.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

No. The very idea makes little sense. Yes, the bigger the database, the more likely that you will have to scan large amounts of data, and that may call for more CPU. However, it depends very much on the workload and how well-tuned indexes are etc. And not the least what sort of data you have. Obviously an archive database with orders from 2010 to 2015 does not require the same power as the database with all the current orders.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.