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

Content with tag Buffer Pool Rss

   Items 1 to 3 of 3   
 

Increasing Buffer Pool in SQL Server 2014

Under heavy load your SQL Server may not work as intended due to lack of resources. To handle this situation SQL Server 2014 gives us the possibility to use an SSD or Ram device to dynamically increase the Buffer Pool. Keep reading to see how you can take advantage of this new wonderful feature.  Read more...
By Additional Articles 2014/02/14 | Source: MSSQLTips.com | Category: buffer pool
Rating:  Rate this |   Briefcase | 2,261 reads

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,910 reads

SQL Server Memory Management Explained

Author Craig Outcalt takes a deep dive into the SQL Server memory allocation and how it competes with OS memory.  Read more...
By Craig Outcalt 2011/09/20 | Source: SQLServerCentral.com | Category: memory
Rating: |  Discuss |   Briefcase | 12,661 reads
   Items 1 to 3 of 3   
 
Tags
data file (1)    
instant file initialization (1)    
local security policy (1)    
lock pages in memory (1)    
memory (1)    
mpa (1)    
multipage allocator (1)    
perform volume maintenance tasks (1)    
single page allocator (1)