Here is my situation:
Total Physical RAM : 128 GB
Assigned to SQL Server : 122 GB (Lock pages in memory for SQL Server Account)
So for OS we have close to 6 GB left now.
Now we are facing issue like below:
SQL Server:Buffer Manager Page writes/sec has exceeded the threshold of 90
Now we are planning to decrease the assigned SQL Server Maximum memory from 122 GB to 111 GB.
I used below links to set maximum server settings for SQL Server.
https://github.com/bornsql/scripts/blob/master/max_server_memory.sql
Will, increasing Physical RAM for OS level help us ?
When I checked the Task Manager process utilization SQL Server doesnot seems to be using a lot of Memory. It is servicehosts and Microsoft Monitoring tool that consumes along with SQL Server occupies second and third position.
I know there are plenty of forums which will help to understand the memory logics in SQL Server but may I know where should I start learning about SQL Server Memory utilization.
How can I find what is consuming the most memory in SQL Server ?
Please advice me ?