Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Adding a Rowversion column to each table for ETL extraction....thoughts? Expand / Collapse
Author
Message
Posted Friday, November 1, 2013 10:07 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 5:03 AM
Points: 112, Visits: 446
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

Post #1510676
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse