Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Lock Pages in Memory Rss

   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 | 6,943 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,414 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,519 reads
   Items 1 to 3 of 3   
 
Tags
buffer pool (1)    
data file (1)    
instant file initialization (1)    
local security policy (1)    
memory management (1)    
perform volume maintenance tasks (1)    
performance tuning (1)    
update (1)