A quick look at: sys.dm_os_buffer_descriptors
Posted
by fatherjack
on Simple Talk
See other posts from Simple Talk
or by fatherjack
Published on Tue, 12 Jun 2012 02:00:00 GMT
Indexed on
2012/06/12
10:45 UTC
Read the original article
Hit count: 173
Filed under:
SQL Server places data into cache as it reads it from disk so as to speed up future queries. This dmv lets you see how much data is cached at any given time and knowing how this changes over time can help you ensure your servers run smoothly and are adequately resourced to run your systems. This dmv gives the number of cached pages in the buffer pool along with the database id that they relate to: USE [tempdb]
GO
SELECT COUNT(*) AS cached_pages_count ,
CASE database_id
...(read more)
© Simple Talk or respective owner
