SELECT tab.name AS Tablename,user_seeks, user_scans, user_lookups, user_updates,last_user_seek, last_user_scan, last_user_lookup, last_user_update
FROM sys.dm_db_index_usage_stats ius
INNER JOIN sys.tables tab ON (tab.object_id = ius.object_id)
WHERE database_id = DB_ID(N'Nombre_BaseDeDatos')
order by last_user_update desc
No comments:
Post a Comment