February 23, 2009 at 11:11 am
I have adjusted Memory in order to try and stop or reduce trimming of working sets.... Stand Edition, 32 gig,2005. I have set the max to 25 gig and min to 20 gig. I know this adjustment is for the buffer pool only but I expected to see that total and target might change but this does not seem to be the case?
As soon as Target and Total = each other then Page Life expectancy drops from 193,000 to 109 then the CPU and Page file goes up and memory is trimmed.
I expected Total memory to stay above 20 gig but this is not the case? What I misunderstanding?
THANKS
February 23, 2009 at 2:56 pm
Did you check your AWE enabled?
February 23, 2009 at 3:18 pm
standard edition, this is not possible, only on Enterprise.
February 23, 2009 at 3:24 pm
have you given the account that runs SQL the 'lock pages in memory' right. This will prevent SQL working set bring trimmed.
And AWE is usable with standard edition in SQL 2005. Unless you are on 64bit you must be using AWE.
---------------------------------------------------------------------
February 24, 2009 at 9:07 am
wish I could George, that would most likely solve my problem.....but you can not lock pages in memory on standard edition......only enterprise....microsoft is looking at this issues know....who knows it they will fix it...
February 24, 2009 at 9:44 am
465789psw (2/24/2009)
wish I could George, that would most likely solve my problem.....but you can not lock pages in memory on standard edition......only enterprise....microsoft is looking at this issues know....who knows it they will fix it...
thats only true for 64 bit, are you on 64 bit? If so, you've been microsofted I am afraid.
a google on 'lock pages in memory' should give you a number of workarounds to try.
---------------------------------------------------------------------
February 24, 2009 at 9:50 am
you are correct its 64 bit.....so since I can not lock pages in memory one of the work arounds is to set max/min memory.
So I set it ..sp_configure 'max server memory', 26214401;...sp_configure 'min server memory', 20971521;
The problem is when I check my permon and check target memory I get 33552552 since I have 32 gig on the system it looks like it is seeing all the memory...not sure why
February 24, 2009 at 10:02 am
Max and min server memory is in MB, so your setting is way too high.
Greg
February 24, 2009 at 10:09 am
Perfect.......Thanks a bunch......dont know what I was thinking.....must of been on Crack!
THANKS again
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply