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

Filed under:

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.

deploymentmanager 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