query to find out the last date on which statistics updated

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Johan Bijnens SSC Guru Points: 135381 More actions · Answer 1

did you try this ?

SELECT index_id

, name AS index_name

, STATS_DATE(OBJECT_ID, index_id) AS statistics_update_date

FROM sys.indexes

-- WHERE OBJECT_ID = OBJECT_ID('dbo.Objects')

order by Index_id;

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 2

shanila_minnu (12/23/2009)
please give a query to find out the last date on which statistics updated

Search-->please give a query to find out the last date on which statistics updated-->Go

Grant Fritchey SSC Guru Points: 398916 More actions · Answer 3

How about DBCC SHOW_STATISTICS?

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt