Sample Header Ad - 728x90

Find out when your index was last rebuilt / reorganized

5 votes
2 answers
30610 views
I've recently come across a database, which has very high fragmentation on large tables. Page count > 1'000'000 with fragmentation 99,... I would like to know how long this table has gone without a reorganize / rebuild. That way I can review changes made on that date, to try and find a cause. (Also it'd look nice on my report "this database has not been properly maintained since...) As I'm in the process of setting up a job to quickly reorganize the affected tables (this night probably), any solution that could offer me a history of index operations would be much appreciated. If not, simply knowing that I can check this data in the future would be very helpful.
Asked by Reaces (2681 rep)
Nov 18, 2014, 02:39 PM
Last activity: Aug 22, 2024, 09:28 AM