Re: Streams advice

DA Morgan says...
> Geoff Muldoon wrote:
> > Frank van Bortel says...
> >> Geoff Muldoon wrote:
> >>
> >>> We are particularly looking at Asynchronous Change Data Capture because it
> >>> "can be configured to have minimal performance impact on the source
> >>> database", so I presume you refer to overheads at the staging database and
> >>> overall server resource levels, rather than within the source databases.
> >>> Maybe overheads of the subscriber databases too?
> >> No - source. Hopefully, things have improved with 10G; 9.2.0.4 was
> >> simply a disaster.
> >
> > Performance within the source? Thought that the only real additional
> > overhead there would be the requirement to bump to supplemental rather
> > than standard logging. Does the log mining process affect performance
> > within the source database process?

> Log Miner is very resource intensive. Don't be surprised if it eats a
> substantial percentage of your server's capabilities.

Thanks for the heads up on that. Might look for our prototype at running the Streams staging instance on separate hardware to isolate resource contention from the OLTP source systems.

Do Redo Transport Services chew much resources on the source systems or, if significant, is that mainly in the staging area as well? I'm assuming that Log Miner runs in the model we're considering (Asynchronous Autolog Mode) on the staging server post log transportation, rather than on the source servers.

TIA Geoff M Received on Thu May 22 2008 - 17:43:04 CDT