April 1, 2011 at 2:38 pm
I have server which have 64 cpu and 16 cpu is set for cpu affinity 16 cpu is set for i/o affinity today ı changed cpu affinity 16 to 32 cpu and memory is decrease 100 gb to
65 gb why the memory is decrease I can t understand this
April 2, 2011 at 5:00 am
Somebody help me 🙂
April 2, 2011 at 8:36 am
I'm not sure I follow you. Are you talking about the max memory setting in SQL Server, the physical memory registered in windows, the amount of memory used by SQL...... I could go on 😀
Also, I could do with know the version number of SQL and Windows. Possibly the hardware the server is hosted in may be useful.
Can I have the affinity mask settings using sp_configure (before and after).
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply