SQL SERVER 2014 - Memory Full even after set value for "max server memory" -
i'm using sql server 2014 on server has 76gb ram. "max server memory" in sql 32 gb, database size 600gb.
sql memory consumption hit 99% , affect server performance. can know reason?
thank you.
i found problem !! in procedure move data sql server mysql every minutes using linked server. linked server activities not included in "max server memory" reason memory full.
Comments
Post a Comment