Finding Out DirtyPages in the Databases.
SELECT db_name ( database_id ) AS 'Database' , count ( page_id ) AS 'Dirty Pages' FROM sys . dm_os_buffer_descriptors WHERE is_modified = 1 GROUP BY db_name ( database_id ) ORDER BY count ( page_id ) DESC