Post reply

Reindexing

  • February 7, 2013 at 1:49 am

    #273907

    I have a server having 20 DB's..... suddenly itis functioning slow.. i am sure that the Re-indexing needs to be done on the DB's

    Please help me with the SQL query to note down which DB's needs to be reindexed...

    Please suggest & also brief abt the query

    ************************************
    Every Dog has a Tail !!!!! :-D

  • February 7, 2013 at 1:58 am

    #1585263

    Query sys.dm_db_index_physical_stats in each db, then you can see what needs re-indexing / re-organising.

    Filter out heaps and anything with a page count < 1000.

    For a script to do the rebuilds, look at Ola's index maintenance script, link found in my signature.

  • February 7, 2013 at 3:10 am

    #1585293

    You can also try to defragment indexes as fragmentation may have increased for indexes

    Rebuild or Reorganize indexes to improve their performance.

  • February 7, 2013 at 3:40 am

    #1585301

    Thanks Anthony & jeet 🙂

    ************************************
    Every Dog has a Tail !!!!! :-D

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

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