SELECT
	Index_Utilization_Summary.Database_Name,
	Index_Utilization_Summary.[Schema_Name],
	Index_Utilization_Summary.Table_Name,
	Index_Utilization_Summary.Index_Name,
	Index_Utilization_Summary.Index_Utilization_Summary_Create_Datetime,
	Index_Utilization_Summary.Index_Utilization_Summary_Last_Update_Datetime,
	Index_Utilization_Summary.User_Update_Count_Total,
	Index_Utilization_Summary.Last_User_Update,
	DATEDIFF(DAY, Index_Utilization_Summary.Index_Utilization_Summary_Create_Datetime, Index_Utilization_Summary.Index_Utilization_Summary_Last_Update_Datetime) AS Days_Without_Reads
FROM IndexMetrics.Index_Utilization_Summary
WHERE Index_Utilization_Summary.User_Seek_Count_Total = 0
AND Index_Utilization_Summary.User_Scan_Count_Total = 0
AND Index_Utilization_Summary.User_Lookup_Count_Total = 0;

Leave a Reply

Your email address will not be published. Required fields are marked *