Lock Pages in Memory

External Article

Great SQL Server Debates: Lock Pages in Memory

  • Article

There has been much debate over the need for the Lock Pages in Memory privilege, on 64-bit versions of SQL Server. Jonathan Kehayias presents a "warts and all" account of its history, the confusions surrounding its use, and why he believes it's still a good default configuration for 64-bit SQL Server instances, even when running Windows Server 2008 and Windows Server 2008R2.

2011-12-29

2,878 reads

Blogs

Is Cataloging Your Data Important?

By

Data continues to be the lifeline for companies across the globe. As maturity levels...

Daily Coping 20 Mar 2023

By

Today’s coping tip is to get outside and notice how the weather feels. This...

Tales From The Field Weekly Wrap Up for the Week of 03-13-2023 & SQLBits 2023

By

 Hello Dear Reader!  What an incredible week we had.  I started off traveling on...

Read the latest Blogs

Forums

Data Problem

By immad

This is the Data ID ----- Date From ------   Date To    ------- 2 ...

Centralized SSIS Server?

By Brandie Tarvin

Has anyone every created / managed a centralized SSIS server? We have a virtualized...

Azure SQL - Restore to lower enviornment

By PJ_SQL

Hello! Backups are automated for Azure SQL Prod environment, we can do point-in-time recovery...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers