• ramana3327 (10/23/2014)


    Yes but now it is hitting the production database performance (OLTP). That is the reason they want the read only copy for the reporting source

    It would be far easier and cost effective to analyze the query(ies) that support the report and fix them so they run more quickly and with fewer resources. 3 orders of maginitude performance increases and resource usage decreases are more common than you think if you just spend some time working the code and maybe some indexes.

    Like Gail suggested, moving the data to a read only copy of the data is going to buy you very, very little especially when compared to how much the cost will be to do so.

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