sys.dm_db_index_usage_stats:ast_us er_update value i s NULL

I am getting the value "last_user_update" as Null by using below query for only some tables.What is the meaning if it is Null.One column got changed and I want to know when it was changed.

SELECT OBJECT_NAME(OBJECT_ID) AS DatabaseName, last_user_update,*
FROM sys.dm_db_index_usage_stats
WHERE database_id = DB_ID( 'dbanme')
AND
OBJECT_ID=OBJECT_ID('tablename')

Kindly help me on this.

<o:p></o:p>

September 10th, 2015 3:02am

The values in the DMV are cleared on system restart. I think it can be cleared by DBCC SQLPERF as well. So the update may have taken place before the DMV was cleared most recently.

Free Windows Admin Tool Kit Click here and download it now
September 10th, 2015 3:16am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics