In one of our PROD Servers...
The Total Physical RAM is 128GB The Total RAM I assigned for SQL Server is 122GB.
When I checked the SQL Server there were no Open Transactions, No Blockings....But still the Memory Consumption is higher and it show 99% in Task Manager and performace has been slowed down.
Should we increase the Memory or I don't understand if OS or SQL Server does not have enough Memory. Please advice if we need to allot some enough Memory to OS too...
