ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

What is the option ”Lock Pages in Memory”?

What is the option Lock Pages in Memory”?

user-image
تم إضافة السؤال من قبل Aslam Khan , Senior SQL Server DBA , IT People Gulf
تاريخ النشر: 2016/11/22
Aroj Ali
من قبل 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
من قبل 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.

المزيد من الأسئلة المماثلة