July 26, 2006 at 1:29 pm
Hello I am receiving this error on sql server start up on 2 clustered instances running sql2000 sp4. (initdata: Warning: Could not set working set size to 2777088 KB.). I do not recall seeing this before. It is a w2k3 cluster with 32gig memory per..
On both instances I have awe enabled and min server memory set to 12 gig and max set to 15 gig.
I do not know why I am beginning to see this? sp4 applied roughly 30 days ago
Any recommendations?
The closest I found was to not dynamically configure between 12 and 15 gig but set min and max the same ??
Should I set set working set size = 0 opposed to 1? to turn it off?
Any help would be appreciated.
July 31, 2006 at 8:00 am
This was removed by the editor as SPAM
July 31, 2006 at 2:32 pm
I think I found the same thing you did. From BOL:
"Do not set set working set size if you are allowing SQL Server to use memory dynamically. Before setting set working set size to 1, set both min server memory and max server memory to the same value, the amount of memory you want SQL Server to use."
I interpret that to mean, yes, you need to either set the "set working set size" option back to zero, or set min & max server memory to the same value.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply