New answers tagged buffer-pool
1
vote
Accepted
How is the size of the buffer pool (data cache) calculated?
With max server memory set to 0, two factors will dictate how much memory SQL Server will use, and thus how big the buffer pool will grow.
But before talking about those, consider that with out any ...
Top 50 recent answers are included
Related Tags
buffer-pool × 102mysql × 43
innodb × 43
sql-server × 37
memory × 21
performance × 12
sql-server-2012 × 11
cache × 7
sql-server-2014 × 6
db2 × 6
plan-cache × 6
mysql-5.7 × 5
sql-server-2017 × 5
transaction-log × 5
data-pages × 5
mariadb × 4
page-life-expectancy × 4
sql-server-2008 × 3
index × 3
mysql-5.5 × 3
mysql-5.6 × 3
database-internals × 3
backup × 2
optimization × 2
availability-groups × 2