How can I tell how much time a particular transaction spends on the database and on which activity?
You can derive the database time of a transaction step from the respective statistical data record in Transaction STAD (formerly: STAT).Note that for extremely long-running programs, there overflows may occur in the components of database time (for values > 2^32 microseconds = 71 minutes), and the subsequent time is wrongly recorded as processing time.To determine which database accesses are primarily responsible for the database response time, you can set the R/3 parameter stat/tabrec (see Note 579462) to a value greater than 0 (-> number of tables to be logged).
Related Questions
- How do I ensure that a new database connection is created each time an EJBs container-managed transaction is started (so that I get a new authentication/authorization each time)?
- How do I ensure that a new database connection is created each time an EJBs container-managed transaction is started (so that I get a new authentication/authorization each time)?
- Do parental permission and child assent for research involving children have to occur at the same time or in any particular order?
- How can I tell how much time a particular transaction spends on the database and on which activity?
- How far back in time may I view transaction activity?
- How far back in time may I view transaction activity?
