checking SQL Server file pages' status

select *
from msdb..suspect_pages