ADM415 Flashcards
(40 cards)
Why is buffer synchronization important in an SAP system with more than one instance?
- To improve performance
- To prevent outdated data from being selected from buffers
What happens when a buffered table is updated by an SQL request?
- Changes are written to table DDLOG, which is read at a certain interval to update the content of the database
- The database is updated and the buffer of the current application server is invalidated
Which of the following areas of an instance’s shared memory has a corresponding file on hard disk to which the SAP system will copy data that would not fit in that shared memory area
- Paging buffer
What does the Expensive Statements trace do?
traces the top 10 SQL statements whose execution time exceeds a configured threshold
What information can be retrieved with transaction Operating System monitor (ST06)?
- Virtual memory
- CPU utilisation
- Physical memory
In the Transaction Workload Monitor (ST03), what is the main indicator of poor database performance?
Average DB request time of more than 40% of average response time.
What is the SAP Operating System Collector (SAPOSCOL)?
An SAP proprietary standalone program for collecting Operating System usage information
Where can you find the top expensive SQL statements on the system?
In the expensive statement view via DBACOCKPIT
Can database request time include network time?
Yes, because database request time is measured at SAP instance level
How can you analyze the response time of SQL statements using HANA Cockpit tools?
- SQL Trace
- Expensive statements
What tool enables central database monitoring and administration of multiple SAP HANA databases?
SAP HANA Cockpit
Which RFC type is used for multiple communication steps that must be completed in a particular order?
Queued RFC (qRFC)
What are some of the reasons for using the extended memory concept in SAP systems?
- The large size of extended memory avoids context switches where possible
- SAP transactions usually consist of more than one step or screen
What information can be retrieved with transaction Local Work Process Overview (SM50)?
- The status of an individual work process, for example, waiting, running, on hold, etc.
- The process ID of the work process
- The program that is currently executed by the work process
Which of the following reports or transactions can be used to monitor extended memory consumption?
- Report RSMEMORY
- Transaction ST02
How is SAP table buffering implemented?
The SAP system saves access to database tables by buffering their contents on instance-specific buffers on application level
Which of the following transactions show historical data?
- Operating System Monitor (ST06)
- Workload Monitor (ST03)
Why are parts of user contexts stored in extended memory instead of the local memory of the work process
To speed up context switches (roll in and roll out)
What is the purpose of buffering data in SAP table buffers?
- To speed up access to data
- To reduce load on the database
What are some of the negative effects of incorrect table buffering settings?
- If a buffered table is very large, there is a risk that other buffered tables will be swapped out because of missing free space
- If the content of a buffered table is changed very often, the process to refill the table buffer can reduce the overall system performance
What is the name of the tool that can be used to monitor the performance of JAVA Systems via Solution Manager?
CA APM Introscope
Which of these alerts might indicate CPU performance issues on the HANA database?
- Most recent savepoint operation (Alert 28)
- Savepoint duration (Alert 54)
- Host CPU Usage (Alert 5)
How can you keep track of the changes applied to a Solution Manager managed system?
Using the tool E2E Change Analysis
What would be the most appropriate Solution Manager tool for customers experiencing performance issues?
E2E Workload Analysis
