top of page

Find the last time tables was updated in DB

  • Writer: skarbnik
    skarbnik
  • Feb 10, 2020
  • 1 min read

SELECT tbl.name ,ius.last_user_update ,ius.user_updates ,ius.last_user_seek ,ius.last_user_scan ,ius.last_user_lookup ,ius.user_seeks ,ius.user_scans ,ius.user_lookups FROM sys.dm_db_index_usage_stats ius INNER JOIN sys.tables tbl ON (tbl.OBJECT_ID = ius.OBJECT_ID) WHERE ius.database_id = DB_ID() order by ius.last_user_update desc

Comments


Search By Tags
bottom of page