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: 302
        
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