Post reply

Gauging Performance Improvement after removing the unused indexes

  • March 19, 2020 at 10:15 pm

    #3735720

    Hi All,

    Removed some of the unused indexes. But, how to identify the performance improvement? Is there anyway to generate any metrics and giving that the managers?

     

    Regards

    Thanks.

  • March 20, 2020 at 2:18 pm

    #3735857

    If you have a baseline of workload before, you could compare it to baseline after.

    Otherwise: user response?

  • March 21, 2020 at 10:03 am

    This was removed by the editor as SPAM

  • March 23, 2020 at 3:52 pm

    #3736303

    you have a few things you need to baseline before you drop the indexes

    individual queries (times and query plans)

    overall CPU

    Overall disk (in and out)

    then you can measure the before and after - perhaps an individual gets reduced from 20 seconds to 1 second, but this makes other parts of the system run badly - this is for you to decide..

    I work with web facing databases, so I try and make sure anything going to a client is prioritised... even if that means nolock on a report that is blocking and extra indexes with include columns. - you just have to assess it for yourself

    MVDBA

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

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