SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Articles with tag Lock Pages in Memory Rss

Search for any content tagged lock pages in memory

   Items 1 to 3 of 3   

Configuring Service Account Privileges for SQL Server

How to grant Windows privileges to the SQL Server's service account.  Read more...
Rating: |  Discuss |   Briefcase | 7,085 reads

Great SQL Server Debates: Lock Pages in Memory

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.  Read more...
By Additional Articles 2011/12/29 | Source: SimpleTalk | Category: lock pages in memory
Rating:  Rate this |   Briefcase | 2,837 reads

Poor Man's Enterprise Feature - Lock Pages in Memory

Enable Lock Pages in memory on Standard edition was ONLY an Enterprise feature until now. Read this article to see how you enable this setting in SQL Server.  Read more...
By Amit Singh 2009/10/15 | Source: SQLServerCentral.com | Category: lock pages in memory
Rating: |  Discuss |   Briefcase | 8,559 reads
   Items 1 to 3 of 3