Hi Again! I'm trying to optimize a database that has just tons and tons of indexes. I've already identified several that don't need to be there based on their selectivity (or complete lack there of). I'd like to know if there's a tool available that can monitor the activity on the database and tell me which indexes are being used and how often. Perhaps there's some way to have Profiler do this? Or maybe a 3rd party tool? Any thoughts or assistance is greatly appreciated. [8] Cheers, Buddy
True, PROFILER does this to some extent, check this link for information http://www.embarcadero.com/news/mssqltuningqwizard.asp], and also search thru this website under Articles for tips and information. _________ Satya SKJ
