Lock Pages in Memory prevents SQL Server from paging out the memory it has allocated . It is a Windows security setting policy. Hence from a performance point of view enabling this option would be good.
But Be cautious when using this setting.
When the maximum memory value is not configured and left as default and you have a lot of load on the sql server ,then sql server will starve other applications from getting any memory because we have not placed any limit on the usage of memory for sql server. So It tries to consume as much memory as it can. Therefore all this memory will be locked and other applications will not be able to use this.
Though in sql server 2005 and 2008, it has been designed that Sql server will release some of the memory to the Operating system if it faces any memory pressure It is not that efficient
So Please configure the Sql Server Memory in such a way that they have an upperlimit and windows have sufficient memory.
No comments:
Post a Comment