Home Forums SQL Server 2008 SQL Server 2008 - General Testing new indexes RE: Testing new indexes

  • May 24, 2018 at 2:59 pm

    #1991914

    alex.palmer - Thursday, May 24, 2018 8:50 AM

    That's what my management are scarred of.  A process we're not aware of battering the table and the new addition  making performance collapse.

    Have you ever used any tools to simulate impact of new indexes on SELECT, UPDATE and INSERTs

    The folks on the front end for our company built a custom load test for our system.  It works fairly well but it's not perfect.

    To be sure, having a goof test system that can simulate the load is great but should be great  Will it catch everything?  Nope.  Its still very worthwhile to do.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)