-- Esse script retorna os databases que não possuem a opção PAGE_VERIFY como CHECKSUM
-- Mais detalhes sobre a propriedada PAGE_VERIFY, aqui

	

	
	SELECT db.[name] AS [Database Name],  db.page_verify_option_desc AS [Page Verify Option],
	is_auto_close_on,is_auto_Shrink_on,
	 db.recovery_model_desc AS [Recovery Model],
      db.log_reuse_wait_desc AS [Log Reuse Wait Description],
      ls.cntr_value AS [Log Size (KB)], lu.cntr_value AS [Log Used (KB)],
     CAST(
			CAST(lu.cntr_value AS FLOAT)	/ case when CAST(ls.cntr_value AS FLOAT) = 0 then 1 else CAST(ls.cntr_value AS FLOAT) end  AS DECIMAL(18,2)
		)* 100 AS [Log Used %],
      db.[compatibility_level] AS [DB Compatibility Level]
FROM sys.databases AS db
	INNER JOIN sys.dm_os_performance_counters AS lu ON db.name= lu.instance_name
	INNER JOIN sys.dm_os_performance_counters AS ls ON db.name= ls.instance_name
WHERE lu.counter_name LIKE 'Log File(s) Used Size (KB)%'
	AND ls.counter_name LIKE 'Log File(s) Size (KB)%'
	and db.page_verify_option_desc <> 'CHECKSUM'   

 
-- Para alterar a opção de page_verify de uma database, deve ser executado o comando abaixo
--ALTER DATABASE NOME_DATABASE SET PAGE_VERIFY CHECKSUM