SELECT CASE page_type
WHEN 'DIFF_MAP PAGE' THEN '差异更改映射(Differential Changed map)'
WHEN 'TEXT_MIX PAGE' THEN '文本混合页(Text Mixed Page)'
WHEN 'ML_MAP_PAGE' THEN '这个字面意思应该是Minimally-Logged,最小化日志记录'
WHEN 'INDEX_PAGE' THEN '索I页(Index Page)'
WHEN 'FILEHEADER PAGE' THEN '文件头页(File Header Page)'
WHEN 'DATA PAGE' THEN '数据页(Data Page)'
WHEN 'IAM_PAGE' THEN '索引分配映射页(IAM Page)'
WHEN 'GAM PAGE'THEN'全局分配快射页(GAM Page)'
WHEN 'BULK OPERATION PAGE' THEN '这个字面意思应该是大容量更改记录'
WHEN 'TEXT_TREE_PAGE' THEN '文本页(Text Tree Page)'
WHEN 'SGAM_PAGE' THEN '共享全局分配映射页(SGAM Page)'
WHEN 'PFS PAGE' THEN '空闲空间跟踪页(PFS Page)'
WHEN 'BOOT_PAGE' THEN '启动页(Boot Page)'
ELSE '排序页？'
END,
page_type,
COUNT(*)cnt
FROM sys.dm_os_buffer_descriptors WITH (NOLOCK)
WHERE database_id= DB_ID()
GROUP BY page_type
