Ansicht
Dokumentation

05103 - DIA vs BTC Performance

05103 - DIA vs BTC Performance

Vendor Master (General Section)   CPI1466 during Backup  
This documentation is copyright by SAP AG.
SAP E-Book

DIA vs BTC Performance

Hi Doreen,

I think, we are not talking about the first run. More interesting are the
other runs. If this is reproducible as it looks like on your box, this
should be handled from IBM with a PMR, because SAP definitely has no
differences between BTC and DIA jobs at all. (Except the different priority,
if you setup it that way.)

Regards

Volker

> -----Original Message-----
> From: Anderson, Doreen [mailto:dandersoZb...]
> Sent: Montag, 18. Februar 2002 17:29
> To: 'DoNotReply@consolut.eu'
> Subject: RE: Re: DIA vs BTC Performance
>
>
> According to your stats this is my observance.....
>
> The first time after building an index and running a program
> it will always run the longest due to building access path /
> SQL package / buffers (see Run 2 below - 10 minutes)
>
> Run 3 - 10 seconds in BTC should have nothing to do with BTC
> vs. DIA - Did you try to run it again in DIA? If yes, you
> should have seen a 10 second response time; since sql
> packages and access paths were built from
>
> Run 4 - 10 seconds (after bringing down SAP)
>
> Run 3 & 4 were both consistently 10 seconds
>
> You always want to run a program at least 2x after building
> an index before you can determine/observe its "true runtime"
>
>
> Run 1 - 30 minutes arrival sequence
> Build Index
> Run 2 - 10 minutes in DIA
> Run 3 - 10 seconds in BTC
> ? Why faster in BTC?
> Bring down SAP
> Run 4 - 10 seconds in DIA
> ? Why faster after bring down SAP
>
>
>
> Doreen Anderson
> Ball Horticultural Company
> dandersoZb...
> (630) 231-3600 x3214

Durban Tours - Südafrika Safari

TXBHW - Original Tax Base Amount in Local Currency   General Data in Customer Master  
This documentation is copyright by SAP AG.

Length: 2596 Date: 20240420 Time: 055242     sap01-206 ( 3 ms )