Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

What is the option ”Lock Pages in Memory”?

What is the option Lock Pages in Memory”?

user-image
Question ajoutée par Aslam Khan , Senior SQL Server DBA , IT People Gulf
Date de publication: 2016/11/22
Aroj Ali
par Aroj Ali , Assistant Manager IT , Cegura Technology Solutions

Lock pages in Memory” Right in Windows ... that Lock Pages in Memory be used as a default configuration option on all

Elsa Ajit
par Elsa Ajit , Senior System Analyst, Collaboration Technologies , Government Organization

when we grant the "lock pages in memory" user right to the SQL Server service account prevents SQL Server buffer pool pages from paging out by Windows. This setting is useful and has a positive performance impact because it prevents Windows from paging a significant amount of buffer pool memory out of the process, which enables SQL Server to manage the reduction of its own working set.

More Questions Like This

Avez-vous besoin d'aide pour créer un CV ayant les mots-clés recherchés par les employeurs?