Query for last date of index rebuild for all databases in a instance

Question

Query for last date of index rebuild for all databases in a instance

sourav dutta 231

Hello,

I can get all database wise last index rebuild date in sql server.

Thanks in advance.

Bert Zhou-msft 3,436 Reputation points

2022-06-23T01:44:54.757+00:00

Hi,@sourav dutta
Do you have further question on this , could we offer more support?
If this helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)

Bert Zhou

Accepted answer

2 additional answers

Your answer

Bert Zhou-msft 3,436 Reputation points

2022-06-23T01:44:54.757+00:00

Hi,@sourav dutta
Do you have further question on this , could we offer more support?
If this helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)

Bert Zhou

Answer 1

Hi，@sourav dutta

Welcome to Microsoft T-SQL Q&A Forum!

All I can say is that it is uncontrollable that you want to get update statistics , rebuild will also update your index information , you can take a look at the index maintenance script written by Michelle Ufford, maybe it can help you.

Best regards,
Bert Zhou

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Tom Phillips 17,771

That data does not exist at a database level. That would be a maintenance job. You could get it from the job history of your maintenance job.

Answer 3

Olaf Helper 47,516

SQL Server don't store (and knows) where an index was last rebuild or reorganized.

sourav dutta 231 Reputation points

2022-06-20T13:24:01.79+00:00

I found the last update date by below query. But it is run on specific database.
I need database wise last update date.

SELECT
MAX(STATS_DATE(object_id, stats_id)) AS LastStatsUpdate
FROM sys.stats

Share via

Query for last date of index rebuild for all databases in a instance

2 additional answers

Your answer