High Memory Usage.
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
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
Post a Comment