Post reply

Managing Indexes in a Database

  • November 30, 2007 at 5:56 pm

    #180873

    I have a database which has a over 80 to 100 indexes. How do we maintain these indexes, I think re-indexing all of them is not a good idea. Is there any other way of monitoring these indexes in SQL Server 2005 for fragmentation etc. Your insight is appreciated!!

    Regards,

    Razi, M.
    http://questivity.com/it-training.html

  • December 1, 2007 at 11:54 am

    #756248

    You can monitor fragmentation with dbcc showcontig and then based on the results, decide which indexes you want to rebuild. Lots of scripts here on the site.

    Other than that, SQL Server maintains the indexes fairly well.

  • December 1, 2007 at 12:51 pm

    #756252

    Thanks Steve. Guess what I told this to an interview but he still wanted to see what else we can do? I was stuck:)

    I think there are some system DMVs in 2005 that show statistical information regarding indexes.

    Regards,

    Razi, M.
    http://questivity.com/it-training.html

  • December 1, 2007 at 2:27 pm

    #756253

    Yes, as far as checking to see if indexes are being used, you can use the DMVs so see what's being used.

    This blog post can help: http://blogs.msdn.com/sqlcat/archive/2006/02/13/531339.aspx

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

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