SQL Server: buffer manager: database pages

VN:RO [1.9.17_1161]
Rating: 5.0/5 (1 vote cast)
1
7,296 0
This metric tells you how many database pages are currently being occupied in the data cache. The higher the buffer manager: database pages is, the less room there is for SQL Server to cache more data pages. Read more

Ad hoc query stubs in plan cache

VN:RO [1.9.17_1161]
Rating: 4.0/5 (1 vote cast)
1
5,435 0 ,
This metric measures the total number of one-time use ad hoc queries in the plan cache that have been stored in the form of a stub, not as a full execution plan. Read more

Buffer cache used per database in MB

VN:RO [1.9.17_1161]
Rating: 4.9/5 (7 votes cast)
7
10,294 0 ,
Knowing how much of your RAM is committed to each database can help you provision the right amount of RAM to SQL Server. It also helps to identify rogue queries that draw too much data into RAM and force data from other databases out of the cache. Read more