How can we be sure that SQL is low on memory? Or what to set up on max Memory value?

Here is a short guide on how to analyze memory needs for an Instance of SQL Server:
 
Use Perfmon Counters to understand SQL Memory needs
 
Considering that you did not set up yet the maximum SQL Server Memory limit, start Perfmon and include the below 3 counters… Continue reading