Hi Gail,

Thank you for the reply, I will raise a CR and then I will reduce the ram memory for the SQL Server, but a doubt on this as how much memory do we need to allocate to the SQL Server in the Max memory.

Hi dbasql79,

Thank you for the query, When I run the query "select Type, SUM(Multi_pages_kb)/(1024.00) Multi_MB From sys.dm_os_memory_clerks

Group by type order by 2 desc " I got the below results

CACHESTORE_SQLCP -----------646.5703125

MEMORYCLERK_SOSNODE-------16.5937500

MEMORYCLERK_SQLSTORENG----12.4453125

CACHESTORE_OBJCP------------7.7578125

And yesterday when I opened the Prod SQL box I got a message that the Virtual memory was also utilized full, so what I need to do to overcome this problem

Thank You in Advance.