MS SQL server Max memory setting

Question

How Much Memory we can allocate to SQL server

Answer 1

For a starting point, we can allocate around 70-80% of the total physical memory to SQL Server. However, this is not mandatory, and you should adjust the setting based on your server's specific characteristics and performance monitoring results. For example, you might not want to suffocate the server by not leaving enough memory left out for OS and other apps. allocate somewhere around 70% (>50%).
Let's say you have 16GB physical memory, then 70% of 16GB would be 11.2 GB. So you can give 11.2 GB for SQL server, and leave the rest 4.8GB for OS and other functionalities. You can do this by using the SQL Server Management Studio in the memory tab > Maximum server memory (in MB) field and entering 11200MB for 11.2 GB