|

SQL Server and Other Topics

rss

I got my start with SQL Server in 1997 with SQL Server 6.5 at BellSouth Cellular. From that point on I've had the opportunity to work on Versions 6.0 to 2014. I specialize in Performance Tuning, High Availability and SQL Development. Contact me through this site or through my Twitter handle @SQLDiver


Buffer Pool Extension...what? SQL Server 2014 New Feature

Have you ever been memory constrained do to physical hardware constraints (or budget constraints)? Well Microsoft has decided to help us out a little bit. The addition of the Buffer Pool Extension, adds the ability to extend buffer pool to nonvolatile random access memory for instance an SSD. 

This functionality allows the buffer pool manager to use the NAND memory from the Flash Storage to maintain a pool of lukewarm pages (Microsoft term not mine). In effect the buffer pool manager is using the Flash Storage as Level 2 buffer pool that only writes clean pages for safety purposes. 

Although the buffer pool extension can be up to 32 times the size of RAM, the recommendation is to maintain a ratio between 1:4 and 1:8. As usual, the optimal ratio can vary, so test as is always the recommendation.

Refer to the following technet article for more information.



Comments are closed.
Showing 0 Comment