ADM415 -2

Question 1

Which profile parameter determines the max number of work processes that can be started

Answer 1

rdisp/wp_no_dia

Question 2

You see very high paging rates (~50% RAM per hour). What would be possible countermeasures?-

Answer 2

• Identify users / programs that cause high memory consumption and optimize expensive SQL statements and suboptimal programming
• Distribute processes that do not need to run on this specific hardware to other hardware with unused capacity

Question 3

You are reviewing RFC data in the transaction Workload Monitor (ST03). Which RFC profile provides information about function modules in other systems that are called from this system?

Answer 3

RFC Client profile

Question 4

How is SAP Dialog Response time defined?

Answer 4

As the timespan between the dispatcher receives a request til he sends out the final response to the front end

Question 5

What are the products on the current ALM product portfolio of SAP?

Answer 5

• SAP CLoud ALM
• SAP Solution Manager
• SAP Focused Run

Question 6

If there are any issues with table buffering or configuration, what transactions could give you more information?

Answer 6

ST10

ST11

Question 7

Which option represents ‘Generic Area Buffered?’

Answer 7

You set some of the key fields for a table to determine the data to be buffered during access

Question 8

What are some of the general memory statistics seen in the Performance Monitor SAP HANA Cockpit?

Answer 8

• Database resident memory
• Physical memory size
• Database allocation limit

Question 9

What buffering types are available in SAP table buffers?

Answer 9

• Generic key buffered
• Single record buffered
• Fully buffered

Question 10

What user is created by default during the HANA Cockpit Installation?

Answer 10

COCKPIT_ADMIN

Question 11

What tool enables central database monitoring and administration of multiple SAP HANA databases?

Answer 11

SAP HANA Cockpit

Question 12

What are dynamic work processes?

Answer 12

Work processes that can change their type while running

Question 13

What are some of the steps used to optimize SAP performance at a technical level?

Answer 13

• Optimization of SAP parameters
• Optimization of database and operating system configuration
• Optimization of SAP system parameters

Question 14

When you run transaction Table Call Statistics (ST10), which of the following indicate that the table should be unbuffered?

Answer 14

• Tables with a high number of invalidations
• Tables with a large buffer size
• Tables with a high number of ‘Rows affected’

Question 15

In transaction Workload Analysis Monitor (St03), average roll-wait time for task type DIALOG is high. Which of the following can cause this issue?

Answer 15

• Problems with the external RFC communication
• Communication problems with the GUI front end

Question 16

What are some typical causes of SAP performance bottlenecks?

Answer 16

• Unsuitable customizing
• Poor data selection by end user
• Long-running programs caused by unnecassary programming statements

Question 17

What are the functions provided by the Database explorer?

Answer 17

• Catalog browser
• SQL Analyzer

Question 18

Which of the following refers to an invalidation of a buffered table?

Answer 18

A buffered table is declared outdated

Question 19

Which of the following are part of the dialog response time?

Answer 19

• Roll-in time
• Enqueue time
• Wait time

Question 20

What are some of the reasons for buffer swaps, which are visible in transaction Buffer Monitor (ST02)?

Answer 20

• Not enough directory entries to buffer the new object
• Not enough space left in the buffer for buffering a new object