Essential Guide

SQL 2014: Investigating Microsoft's latest database release

A comprehensive collection of articles, videos and more, hand-picked by our editors

SQL Server buffer pool

An SQL Server buffer pool, also called an SQL Server buffer cache, is a place in system memory that is used for caching table and index data pages as they are modified or read from disk. 

An SQL Server buffer pool, also called an SQL Server buffer cache, is a place in system memory that is used for caching table and index data pages as they are modified or read from disk. 

The primary purpose of the SQL buffer pool is to reduce database file I/O and improve the response time for data retrieval. In SQL Server 2014, administrators can extend the buffer pool to a nonvolatile storage device such as a solid-state drive (SSD) or an SSD array. SQL Server writes only clean pages to the buffer extension in order to minimize the risk of data loss. By extending the buffer pool, administrators can realize performance gains for online transaction processing (OLTP) workloads, especially those that are read-intensive.

This was first published in March 2014

Continue Reading About SQL Server buffer pool

Glossary

'SQL Server buffer pool' is part of the:

View All Definitions

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Essential Guide

SQL 2014: Investigating Microsoft's latest database release

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

File Extensions and File Formats

Powered by:

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close