TwoPanelCompareTool2 - TableIndexLastAnalyzed
3/20/2010 01:55:00 PM
Jsc Jwhat Jerome Christopher
, Posted in
Sqlhtm Tools
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