High Memory Usage.


hello,

have sql server 2012 standrad edi64bit server.it using 94% memory.our ram size 36gb.it using 34gb.
usage normal?normal sql consume of available memory on machine.
if set max server memory value there affect resources available sql.please suggest me solution.

thank reply.

reducing maximum memory may impact performance right.to avoid in future can please suggest has done.do need make other settings.

reducing max server memory might affect environment possible might not. difficult here dont have knowledge system.changing max server memory value changes buffer cache after changing value might see slowness initial  queries cope up.

change value when have maintenance period sql server. sql server taking memory normal behavior unless find out out of memory errors or perfmon counters have memmory pressure. please check section 'does system has low memory ' in below link confirm memory pressure

http://social.technet.microsoft.com/wiki/contents/articles/22316.sql-server-memory-and-troubleshooting.aspx#does_my_system_have_low_memory 


please mark reply answer if solved issue or vote helpful if helped other forum members can benefit it.

my technet wiki articles




SQL Server  >  SQL Server Database Engine



Comments

Popular posts from this blog

Conditional formatting a graph vertical axis in SSRS 2012 charts

Register with Power BI failed

SQL server replication error Cannot find the dbo or user defined function........