Please help me in this situation.
Total memory on box : 10 GB
Single node, non clustered production box
Min memory is set to 0
Max Memory is set to 8 GB
From last month the box Memory is constantly at 95%
CPU usage is very low
here is the screen shot from the task manager
How to find
Is SQL server using the complete 8GB ?
Management is asking to reduce the SQL server memory setting to 7GB
Is this fine to decrease the memory limit. Please advice.