• SQL Profiler and the Index Tuning Wizard.

    With SQL Profiler, you can capture long running queries to concentrate on first, or you could do a general capture for feeding the Index Tuning Wizard.


    David R Buckingham, MCDBA,MCSA,MCP