I'm trying to find whether there is a dmv or system view that can help me see the last time an index was rebuilt or created. Assuming I rebuilt an index using tsql commands (not a job with a history), is there a way to find out the last time that index was rebuilt?
Thanks much.
Perhaps the information you seek is available here:
SELECT *
FROM sys.dm_index_usage_stats
|||Arnie,
Thank you for your reply. I'm afraid that I have not seen the information I'm after in any of the documented columns of the dmvs. I've combed through the dmvs related to indexes and have been unable to find it. That's why I'm wondering if this metadata is stored elsewhere, and if so, where.
If, when looking at the dmv you mentioned, you saw a particular column you think contains the information I'm after, please let me know what it is.
Thanks!
No comments:
Post a Comment