Adding a Rowversion column to each table for ETL extraction....thoughts?

• DominantDBA

  SSC Eights!

  Points: 862

  More actions

  November 1, 2013 at 10:07 am

  #300612

  Hi All

  Im in a position where we wish to be able to extract what has been changed

  since their last extract as part of the Data warehouse load.

  The primary OLTP system is being mirrored through alwayson onto an asynchronous secondary where they will be pulling their extracts from

  I've been doing some reading on this and generally what I am seeing is performance only becomes a problem when it comes to querying the data which in this case will be done on the async secondary

  so the only things I can think of is less data per page so more space in memory required to cache the database. Its a new system so I am trying to think about possible performance problems that may be seen in future? Essentially looking for the solution that will be the least intrusive into the OLTP application

  Any thoughts would be greatly appreciated

  I am also looking in to change tracking and CDC , however these are not supported supposedly on async's in AlwaysOn and would have to be implemented on the Primary

  Thanks