• DimPerson - Thursday, December 28, 2017 1:36 AM

    I think it's up to you, and it depends what you are using the UAT environment for?
    If you are simply testing any changes or bespoke work, then maybe you aren't worried about how the work performs underneath.
    However, if you want the testing to be representative of a production environment, then I would suggest making them as similar as possible. This way you have a chance of spotting issues before they become problems.
    In my current setup, we have a test environment that mimics our live system. We also have a dev system, which obviously matches the live system in terms of the data, but the configuration of the vm is slightly different, as I'm personally not that bothered about performance here (or any developers 😛). This is what UAT is for.

    Finding performance issues in UAT is finding it too late.  It costs too much in rework or, worse yet, some bloody schedule dictates that the code will still be released to production even with the performance problems present.

    --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)