Multi-Search3

TwoPanelCompareTool2 - TableIndexLastAnalyzed


TwoPanel_TabInd_LastAnalyzed.bat
Run this script to create and view the last-analyzed information of non-sys tables and indexes.

Queries running too slow.

I go on a wild-goose-chase checking log files, trace files, and every tuning trick in the wide, wide world.
Hey, why did I not remember to check the last analyzed information of the tables and the indexes first?

http://www.sqlhtm.com/sqlhtm/twopaneltabindlastanalyzed

BlogCollage


Blog Collage - Top Random Posts In No Particular Order

Mouseover the images for title and comments