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