SQL Monitor Performance Metric: Buffer Cache Used Per Database in MB
Posted
on SQL Server Central
See other posts from SQL Server Central
Published on Tue, 15 Oct 2013 06:00:00 UT
Indexed on
2013/10/18
4:08 UTC
Read the original article
Hit count: 244
Data pages read from disk are placed in the buffer pool with the intention that they will be reused, and accessing them from RAM is faster than from disk. Knowing how much of your RAM is committed to each database can help you provision the right amount of RAM to SQL Server, and also to identify rogue queries that draw too much data into RAM and force data from other databases out of the cache.
Deployment Manager 2 is now free! The new version includes tons of new features and we've launched a completely free Starter Edition! Get Deployment Manager here |
© SQL Server Central or respective owner