August 5, 2012 at 11:55 pm
Hello,
one of our Prod sqlserver is taking 6.5gb memory out of total 8gb of the system.It is 2008R2 64bit standard edition.
I ran memorystatus and found BUFFERPOOL committed and Target values are same which is equal to value=920406
Please provide your inputs for decreasing the sqlserver memory.
August 6, 2012 at 12:16 am
Why do want to decrease SQL Server memory? Do you have any other application on the machine which is having memory issue?
Have you set Max Server memory?
August 6, 2012 at 12:32 am
we are receiving continuous alerts for Highmemory usage regarding sqlserver,maxserver memory is set to 2147483647.
August 6, 2012 at 12:36 am
That means max server memory is NOT set.
Please set max server memory to appropriate value.
August 6, 2012 at 1:46 am
what are the parameters we need to check before setting maxserver memory.
our server is running with 8gb,what is the suggested max memory
August 6, 2012 at 2:20 am
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply