Quick script just to give you an idea of how your databases are being used. Mainly useful for exploring.
select db.name as DatabaseName,
sum(usage.user_seeks) as UserSeeks,
sum(usage.user_lookups) as UserLookups,
sum(usage.user_updates) as UserUpdates
from sys.dm_db_index_usage_stats usage
inner join sys.databases as db on db.database_id = usage.database_id
group by db.name
Hey look! Short script. Longer posts will start back up after Thanksgiving.
Post a Comment
All opinions welcome! Please comment with any changes thoughts or discussion points.