anoop.mig29 (9/4/2013)
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
Nothing. You set the max memory it can use.
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
Nothing. You set the max memory it can use.
3>setting max server memory option does limit memort for all sql server components or only that of buffer pool
Buffer pool (which is the larges component of SQL's memory usage)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability