Post reply

sql 2005 tuning advisor created index in PROD

  • September 18, 2008 at 7:50 pm

    #123785

    I did run the tuning advior in PROD for recomendations; it affected the performance; I had to kill the process as users screamed; when I looked at the table; it has created about 15 indexes in the table; Now how i can get rid of those indexes? pls help; I jsut selected all default options;

  • September 18, 2008 at 8:54 pm

    #873990

    Pick the indexes and right click, select delete or drop.

  • September 19, 2008 at 2:42 am

    #874055

    Lesson: Stop trusting the index tunig advisor. It will always come up with new indexes. There are some scripts on this site which shows the effectiveness of an index (number of updates compared to the number of hits) These scripts are based on data in table sys.dm_db_index_usage_stats

    That's a good point to start evaluating your indexes.

    Wilfred
    The best things in life are the simple things

  • September 19, 2008 at 6:13 am

    #874149

    thanks for your helps.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply