Browse by Tags

• Take it a step further with the index DMV's

  In SQL 2000 I wanted to find unused indexes but found it to be difficult. I had to capture a huge trace that fully represents the workload and “trust” that the ITW knows what it’s talking about. You could also use the scan started trace event filtered... Posted Nov 25 2007, 01:05 AM by JasonMassie with | with no comments Filed under: Indexes, DMV, PerformanceTuning