Performance & Tuning

What does the profile parameter stat/level control, and why should collection stay on?

In STATS, how do you preserve selected statistical records past the stat-file age limit?

What does the EarlyWatch view of the ST03 transaction profile do that the standard view doesn't?

Why is the roll wait time always zero for a background dialog step?

How does table data size guide the choice of buffering type?

Which background job builds the workload aggregates from raw stat records?

What can program RSMEMORY change dynamically, and what stays fixed?

What is the dispatcher wait time component of response time?

Which transaction is the recommended successor to STAD for viewing individual statistical records?

Which standard makes weekly workload aggregates run Monday–Sunday, even where the week locally starts on Sunday?

What does the ST03 “Last-Minute Load” function do?

Why doesn’t all GUI roundtrip time show up as roll wait time?

What does the ABAP program buffer (PXA) hold?

How do you change the ST03 time profile from its default night-bundling to true hourly intervals?

What is the Extended Passport (EPP) in a statistical record used for?

Why are customizing tables good candidates for table buffering?

How is GUI time (TGUI) calculated for a dialog step?

Which transaction analyzes a table's size and key-value distribution to finalize a buffering decision?

Why can't CPU time be added to the other response time components as a separate term?

After an instance restart, how long before ST02 buffer statistics become meaningful?

Why can’t ST03 workload aggregates be read with SQL, and what do you use instead?

In a stat record’s DB tab, what “ms per row” rule of thumb flags a possible database access problem?

What four conditions should a table meet to qualify for buffering?

From ST10 table call statistics, how do you compute a table's read/write ratio?

What does the ST03 response time distribution profile answer?

Which response time metric most precisely measures time spent waiting on remote function calls?

What are the three table buffering methods?

What is transaction ST03 used for?

How does SAP buffer synchronization inform other instances that a buffered table changed?

What does the parameter stat/max_files effectively control, and what is its maximum?

When does the load/generation time (TL) become significant in the response time?

In the response-time breakdown, how is the processing time (TP) derived?

On the STATS selection screen, what does the time you specify actually represent?

What is the “weekend problem” with raw statistical records?

What happens to the SAP HANA SQL plan cache when it fills up?

Where, and in what format, are raw statistical records stored?

How does the roll mechanism use extended memory to pass context between work processes?

Why look at raw statistical records instead of just the workload aggregates?

Which ST03 function helps detect that one application server is performing worse than the others?

What can happen if SAP HANA memory usage frequently hits the allocation limit?

In a statistical record, how can you tell a dialog step was actually a debugging session?

How do stat files rotate over time?

How do you enable table-access logging in stat records, and what does the stat/tabrec value set?

Why can today’s system-wide (TOTAL) workload aggregates look stale, and how do you force an update?

Why is roll-in of a transaction context cheap on modern SAP systems?

When do SAP buffer size parameter changes take effect, and where are they set?

Which two tools can an administrator use to view SAP HANA performance data?

What do the two ST03 ranking lists show?

Why is the performance data of a timed-out (TIME_OUT dump) dialog step unreliable?

In the Data Dictionary technical settings, what are the three table buffering options?

What does transaction ST06 monitor?

In DBACOCKPIT, what determines whether expensive SQL statements get logged?

In SAP performance metrics, what does the application response time R include and exclude?

When a row in a buffered table is changed, what gets invalidated for each buffering type?

What does the enqueue time TENQ measure, and what does it exclude?

Which two SAP buffers are exceptions to the “zero object swaps” goal?

How is user-perceived response time computed from R and the frontend network time?

In which transaction can you see that dialog work processes have gone into PRIV mode?

Why does a work process entering PRIV (private) mode threaten performance?

Which task types in the ST03 workload overview are the main ones to review?

What must be activated for ST06 to show historical server data (blank by default)?