For a physical server , is there a recommended value for SQL that if 16 cores the server memory should be 128 GB etc
For a physical server , is there a recommended value for SQL that if 16 cores the server memory should be 128 GB etc
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
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
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.
14 people are following this question.