GilaMonster (9/3/2013)
Err... the second line of my post....As for why SQL's using the memory, because it can. Because it has not been told that it can't (via max server memory). Set max server memory and have a read through chapter 4 (which is around 15 or so pages) for all the details on what to set it to, how SQL uses memory, queries that let you view memory usage, etc.
Thanks gail one last question
suppose sytem is 64 bit
suppose i set max server memory to certain value , enabled lock pages in memory is enabled, now suppose sql server requires memory more then that what i have set.so then what server do , will it acquire form os.
2> secound suppose sytem is 32 bit and awe is eanbled ,so is lock pages in memory min .max server option is set too,what happens in this scene
3>setting max server memory option does limit memort for all sql server components or only that of buffer pool