DEFINITIONS

Definitions More Info.
Definition ID921
TitleSQL
CategoryNOTES
DefinitionClean and Dirty Pages On Databases
Definition Descriptionhttps://logicalread.com/sql-server-memory-buffer-pools-pd01/

SELECT (CASE
WHEN ( [database_id] = 32767 ) THEN 'Resource Database'
ELSE Db_name (database_id)
END ) AS 'Database Name',
Sum(CASE
WHEN ( [is_modified] = 1 ) THEN 0
ELSE 1
END) AS 'Clean Page Count',
Sum(CASE
WHEN ( [is_modified] = 1 ) THEN 1
ELSE 0
END) AS 'Dirty Page Count'
FROM sys.dm_os_buffer_descriptors
GROUP BY database_id
ORDER BY DB_NAME(database_id);
RecordBycunay
Record Date19-03-2019 14:11:06
Düzenle
Kopyala
Sil