Saturday, March 15, 2014

Find out the last usage date of each database

SELECT
stat.database_id AS database_id
,db.name AS database_name
,MAX(stat.last_user_scan) AS last_user_scan
FROM  sys.dm_db_index_usage_stats AS stat
JOIN sys.databases AS db
ON db.database_id = stat.database_id
GROUP BY stat.database_id,db.name
ORDER BY db.name ASC

No comments: