Buffers Monitor SAP Library Quiz
- 1.
Which of the following areas of an instance's shared memory have corresponding files on the...? 2 OPTIONS
- A.
Paging Buffer
- B.
Extended memory
- C.
Roll buffer
- D.
SAP buffers
Correct Answer(s)
A. Paging Buffer
C. Roll bufferExplanation
The areas of an instance's shared memory that have corresponding files on the system are the Paging Buffer and the Roll buffer. The Paging Buffer is a portion of the shared memory used for storing frequently accessed database pages, while the Roll buffer is used for storing temporary data during database operations. Both of these areas have corresponding files on the system to ensure data persistence and efficient memory management.Rate this question:
-
- 2.
In the transaction Workload monitor st03n, what is the main indicator of poor database performance?
- A.
Av db request time is more than 100ms
- B.
Av db request time of more than 40% of average response time
- C.
Av db request time is higher than average cpu time
- D.
Av db request time of more than twice the average cpu time
Correct Answer
B. Av db request time of more than 40% of average response timeExplanation
The main indicator of poor database performance in the transaction Workload monitor st03n is when the average database request time is more than 40% of the average response time. This suggests that a significant portion of the response time is being spent on database requests, indicating potential performance issues with the database.Rate this question:
-
- 3.
Where can you find the explain plan for an expensive SQL statement? 2 OPTIONS
- A.
Transaction SQL trace st05 or st12
- B.
Transaction workload monitor st03n
- C.
Transaction SAP buffer monitor st02
- D.
Transaction dbacockpit or performance overview st04
Correct Answer(s)
A. Transaction SQL trace st05 or st12
D. Transaction dbacockpit or performance overview st04Explanation
The explain plan for an expensive SQL statement can be found in Transaction SQL trace st05 or st12. Additionally, it can also be found in Transaction dbacockpit or performance overview st04. These transactions provide detailed information about the execution plan of the SQL statement, allowing for analysis and optimization of its performance. The Transaction workload monitor st03n and Transaction SAP buffer monitor st02 do not provide the explain plan for SQL statements.Rate this question:
-
- 4.
When you are investigating a database performance issue you find an often used expensive query. How can you improve performance of this query?
- A.
By educating end users to use the program that calls this sql statement correctly
- B.
By creating an index using selective fields from where clause
- C.
By updating the statistics, so the opitimizer will create an app index
- D.
By creating an index using all the fields from the where clause
Correct Answer
B. By creating an index using selective fields from where clauseExplanation
Creating an index using selective fields from the WHERE clause can improve the performance of the query. By creating an index on the specific columns used in the WHERE clause, the database can quickly locate the relevant data, reducing the need for full table scans and improving query execution time. This index will help optimize the query and make it more efficient, resulting in improved performance.Rate this question:
-
- 5.
In which sequence do dialog work processes allocate memory?
- A.
Roll area -> extended memory -> heap memory
- B.
Initial part of roll area -> extended memory -> remaining part of roll area -> heap
- C.
Initial part of roll area -> heap -> remaining roll -> extended
- D.
Roll area -> heap -> extended memory
Correct Answer
B. Initial part of roll area -> extended memory -> remaining part of roll area -> heapExplanation
The correct answer explains the sequence in which dialog work processes allocate memory. It states that the initial part of the roll area is allocated first, followed by extended memory. Then, the remaining part of the roll area is allocated, and finally, heap memory is allocated. This sequence ensures that the necessary memory is allocated in the required order, optimizing the memory allocation process for dialog work processes.Rate this question:
-
- 6.
Why is buffer sync important in an sap system with more than one instance? 2 OPTIONS
- A.
To improve performance
- B.
To prevent outdated data being commited to the database
- C.
To reduce the load on the db
- D.
To prevent outdated data from being selected from buffers
Correct Answer(s)
C. To reduce the load on the db
D. To prevent outdated data from being selected from buffersExplanation
Buffer sync is important in an SAP system with more than one instance because it helps to reduce the load on the database. By synchronizing the buffers across multiple instances, it ensures that each instance has the most up-to-date data. This prevents outdated data from being selected from the buffers, improving data accuracy and reliability. Additionally, by reducing the load on the database, buffer sync helps to improve system performance and response times.Rate this question:
-
- 7.
You are reviewing rfc data in the transaction workload monitor st03n. which rfc profile provides information about function modules in other systems that are ..
- A.
Rfc server profile
- B.
Rfc client profile
- C.
Rfc server-destination profile
- D.
Rfc client-destination profile
Correct Answer
B. Rfc client profileExplanation
The RFC client profile provides information about function modules in other systems that are being called by the current system. This profile helps monitor and analyze the performance and usage of RFC calls made by the current system as a client. It provides details about the function modules being called, the systems they are called from, and other relevant information for performance analysis and optimization.Rate this question:
-
- 8.
What is the main indicator of a cpu bottleneck?
- A.
Cpu time more than twice the database request time
- B.
CPU time more than 200 ms
- C.
Processing time more than twice the CPU time
- D.
CPU time more than twice processing time
Correct Answer
C. Processing time more than twice the CPU timeExplanation
The main indicator of a CPU bottleneck is when the processing time is more than twice the CPU time. This means that the CPU is taking longer to process tasks compared to the time it is actually spending on executing those tasks. This can indicate that the CPU is struggling to keep up with the workload, leading to a bottleneck in the system's overall performance.Rate this question:
-
- 9.
What is the purpose of buffering data in SAP table buffers 2 OPTIONS
- A.
To reduce load on the database
- B.
To save space on the hard disk
- C.
To create better access paths to data
- D.
To speed up the access to data
Correct Answer(s)
A. To reduce load on the database
D. To speed up the access to dataExplanation
Buffering data in SAP table buffers serves two main purposes. Firstly, it helps reduce the load on the database by storing frequently accessed data in memory. This reduces the number of database queries required, improving overall system performance. Secondly, buffering data helps speed up the access to data by providing faster access paths. By keeping frequently accessed data in memory, SAP can retrieve it quickly, resulting in faster response times for users. Therefore, buffering data in SAP table buffers helps optimize system performance by reducing database load and improving data access speed.Rate this question:
-
- 10.
Are investigating a performance problem in transaction work process overview SM 50 what do you do next
- A.
Click the top 42 CPU processes in transaction operating system monitor ST06N
- B.
Analyse the database
- C.
Analysed SAP memory configuration
- D.
Perform a LAN check by ping
Correct Answer
C. Analysed SAP memory configurationExplanation
After investigating a performance problem in the transaction work process overview SM50, the next step is to analyze the SAP memory configuration. This is important because memory configuration can have a significant impact on system performance. By analyzing the SAP memory configuration, one can identify any potential issues or bottlenecks that may be causing the performance problem. This step will help in understanding and optimizing the memory usage, which can ultimately improve the overall performance of the system.Rate this question:
-
- 11.
What are reserved work processors
- A.
Dialogue work processes that can only be used for a specific task
- B.
Work processes are used to perform nonurgent changes to the database
- C.
Word processor use to communicate with printers
- D.
Work processes that are started in certain situations and stopped again when no longer needed
Correct Answer
A. Dialogue work processes that can only be used for a specific taskExplanation
Reserved work processors are dialogue work processes that are dedicated to performing a specific task. These work processes are allocated for a particular purpose and cannot be used for any other tasks. They are not meant for performing nonurgent changes to the database or for communication with printers. Reserved work processors are started in certain situations when their specific task is required and are stopped when they are no longer needed.Rate this question:
-
- 12.
Should optimise statistics be kept up-to-date
- A.
By using scheduled periodic refreshes
- B.
By triggering the a AS ABAP update work process
- C.
By using of the update jobs are scheduled when an issue occurs
- D.
By manual updates to avoid inconsistencies
Correct Answer
A. By using scheduled periodic refreshesExplanation
Scheduled periodic refreshes should be used to keep optimise statistics up-to-date. This means that the statistics should be refreshed at regular intervals to ensure they accurately reflect the current state of the system. This approach helps to maintain the integrity and accuracy of the statistics, allowing for better performance optimization and decision-making based on the most recent data.Rate this question:
-
- 13.
Transaction workload analysis monitor ST03N, average roll wait time for task type which of the following can cause this issue 2 OPTIONS
- A.
Not enough dialogue work processes configured
- B.
Communication problems with the GUI front-end
- C.
SAP roll area is too small
- D.
Problems with the external RFC communication
Correct Answer(s)
B. Communication problems with the GUI front-end
D. Problems with the external RFC communicationExplanation
Communication problems with the GUI front-end and problems with the external RFC communication can cause an increase in the average roll wait time for task type in the transaction workload analysis monitor ST03N. These issues can lead to delays in communication between the front-end and the SAP system, resulting in longer wait times for tasks to be processed. This can impact the overall performance and efficiency of the system.Rate this question:
-
- 14.
What our dynamic work processes
- A.
Work processes the can change their type while running
- B.
Work processes that are used to process dynamic requests
- C.
Dialogue work processes that can only be used for a specific task
- D.
Work processes that are started in certain situations and stopped again when no longer needed
Correct Answer
D. Work processes that are started in certain situations and stopped again when no longer neededExplanation
The correct answer is "Work processes that are started in certain situations and stopped again when no longer needed." This answer describes dynamic work processes that are initiated based on specific conditions or events and can be terminated when they are no longer required. These processes are flexible and can adapt to changing circumstances, making them efficient and resource-saving.Rate this question:
-
- 15.
What is the ASAP operating system collector
- A.
An SAP proprietary standalone program for collecting operating system usage information
- B.
A third-party tool for collecting operating system uses information
- C.
An alternative transaction operating system monitor ST06N for non ABAP systems
- D.
The built in tool in aBAP systems for collecting operating system usage information
Correct Answer
A. An SAP proprietary standalone program for collecting operating system usage informationExplanation
The correct answer is an SAP proprietary standalone program for collecting operating system usage information. This means that the ASAP operating system collector is a program developed by SAP that is used to gather information about the usage of the operating system. It is a standalone program, meaning it can be used independently and does not require any other software or tools. The purpose of the program is to collect data on how the operating system is being utilized, which can be useful for monitoring and optimizing system performance.Rate this question:
-
- 16.
Transactional work process overview SM 50 or SM 66 you see that many work processes are. What do you do to identify the cause of this issue
- A.
Check top 40 CPU processes in transaction operating system monitor ST06N
- B.
Perform a detailed analysis of the database
- C.
Checking for work processes in Priv mode are using the same transaction or report and
- D.
Check the extended memory usage in the transaction tune summary monitor ST02 and
Correct Answer
C. Checking for work processes in Priv mode are using the same transaction or report andExplanation
To identify the cause of the issue, one should check if work processes in Priv mode are using the same transaction or report. This can help determine if there is a specific transaction or report that is causing multiple work processes to be active. By identifying and addressing any issues with this specific transaction or report, the number of work processes can be reduced.Rate this question:
-
- 17.
Which Elements of total response time should be on the 20 milli seconds 2 OPTIONS
- A.
Role in time
- B.
Database request time
- C.
Wait time
- D.
Processing time
Correct Answer(s)
A. Role in time
C. Wait timeExplanation
The elements of total response time that should be on the 20 milli seconds are the "Role in time" and "Wait time". The "Role in time" refers to the time taken by the server or system to process the request and generate a response. The "Wait time" refers to the time spent waiting for resources or other processes to complete before generating a response. These two elements are crucial in determining the overall response time experienced by the user.Rate this question:
-
- 18.
Where can you find a top expense of SQL statements on the system
- A.
In transaction work process overview SM 50 or SM 66
- B.
In transaction SQL trace ST05 or ST 12
- C.
In the cursor cache of the dBA cockpit
- D.
In the transaction operating system monitor ST06N
Correct Answer
C. In the cursor cache of the dBA cockpitExplanation
In the cursor cache of the dBA cockpit, you can find a top expense of SQL statements on the system. The cursor cache in the dBA cockpit is a storage area that holds frequently executed SQL statements and their execution plans. By analyzing the cursor cache, administrators can identify the SQL statements that consume the most resources, such as CPU or memory, and optimize them for better performance. This information helps in identifying and addressing performance bottlenecks in the system.Rate this question:
-
- 19.
What does zero administration memory management do
- A.
It makes entering priv mode impossible
- B.
It prevents the administrator of the system from setting any memory parameters
- C.
It allows our memory parameters to be said automatically
- D.
It allows total extended memory size to grow dynamically allows other memory parameters
Correct Answer
D. It allows total extended memory size to grow dynamically allows other memory parametersExplanation
Zero administration memory management allows the total extended memory size to grow dynamically and also allows other memory parameters to be set automatically. This means that the system can allocate and manage memory resources without any manual intervention from the administrator. It eliminates the need for the administrator to manually set memory parameters and allows the system to adapt to changing memory requirements.Rate this question:
-
- 20.
Which RFC type is used for multiple communication steps that must be complete in a
- A.
Synchronous RFC
- B.
Queued RFC
- C.
Asynchronous RFC
- D.
Transactional RFC
Correct Answer
B. Queued RFCExplanation
Queued RFC is the correct answer because it is used for multiple communication steps that must be completed in a specific order. In a Queued RFC, the system ensures that the steps are executed sequentially, guaranteeing the correct order of operations. This is particularly useful when there is a dependency between the steps and they need to be executed one after the other. Other types of RFCs, such as Synchronous RFC, Asynchronous RFC, and Transactional RFC, do not necessarily guarantee the sequential execution of steps.Rate this question:
-
- 21.
When you run transaction table call statistics S T 10, which of the following indicates that 3 OPTIONS
- A.
Tables with buffer state pending
- B.
Tables were high number of rows affected
- C.
Tables with more Direct reads
- D.
Tables with a large buffer size
- E.
Tables with a high number of invalidation
Correct Answer(s)
B. Tables were high number of rows affected
D. Tables with a large buffer size
E. Tables with a high number of invalidationExplanation
The correct answer is "Tables were high number of rows affected, Tables with a large buffer size, Tables with a high number of invalidation." When running the transaction table call statistics S T 10, these options indicate different aspects of the transaction tables. "Tables were high number of rows affected" suggests that there were a significant number of rows modified or impacted by the transactions. "Tables with a large buffer size" indicates that the tables required a large amount of memory for buffering data. "Tables with a high number of invalidation" suggests that there were many invalidations or changes to the data in the tables.Rate this question:
-
- 22.
Which of the following transactions can you use to monitor the performance of an ASAP system 3 OPTIONS
- A.
A B a P dictionary SE 11
- B.
Work Process overview SM 50 and SM 66
- C.
System log in local analysis Sm 21
- D.
S a P operating system monitor ST06 OSo7n
- E.
Workload monitor ST03N
Correct Answer(s)
B. Work Process overview SM 50 and SM 66
D. S a P operating system monitor ST06 OSo7n
E. Workload monitor ST03NExplanation
You can use the Work Process overview SM 50 and SM 66 transaction to monitor the performance of the work processes in the ASAP system. This transaction provides information about the status and performance of individual work processes. The S a P operating system monitor ST06 OSo7n transaction allows you to monitor the performance of the operating system on which the ASAP system is running. This includes information about CPU usage, memory usage, and other system-level metrics. The Workload monitor ST03N transaction allows you to monitor the workload and performance of the ASAP system as a whole, including information about response times, throughput, and resource utilization.Rate this question:
-
- 23.
A customer system is setup with many identical instances. Some instances have a… how can a customer resolve this issue
- A.
Increase in the size of the Internet server cache and unfound object cache
- B.
IncreaseThe S a P web dispatcher or, if already in use, check its configuration
- C.
Increase the number of work processes on all instances
- D.
Disable the ICM for the high load instances
Correct Answer
B. IncreaseThe S a P web dispatcher or, if already in use, check its configurationExplanation
To resolve the issue of some instances having high load, the customer can increase the SAP web dispatcher or check its configuration if it is already in use. The web dispatcher helps distribute the load among the instances, so increasing its capacity or ensuring its configuration is optimal can help balance the load and resolve the issue.Rate this question:
-
- 24.
What data is available in the transaction buffer monitor st02 2 OPTIONS
- A.
Status information of buffers on the SAP system
- B.
Information on operating system level paging/Swapping
- C.
On the memory usage of the SAP instance
- D.
Status information of buffers of the SAP instance
Correct Answer(s)
C. On the memory usage of the SAP instance
D. Status information of buffers of the SAP instanceExplanation
The transaction buffer monitor ST02 provides status information of buffers on the SAP system, as well as information on the memory usage of the SAP instance. It does not provide information on operating system level paging/swapping.Rate this question:
-
- 25.
Which of the following sql statement types always bypass the sap table buffers? 3 OPTIONS
- A.
Select distinct statements
- B.
Open sql statements
- C.
Select single statements
- D.
Native sql statements
- E.
Select for update statements
Correct Answer(s)
A. Select distinct statements
D. Native sql statements
E. Select for update statementsExplanation
The SQL statement types that always bypass the SAP table buffers are select distinct statements, native SQL statements, and select for update statements. Select distinct statements retrieve only unique values from a table, bypassing the buffer as it needs to access the actual data. Native SQL statements allow direct interaction with the database, bypassing any buffering mechanisms. Select for update statements are used to lock the selected rows for update, bypassing the buffer to ensure data consistency.Rate this question:
-
- 26.
Why are parts of user contexts in extended memory instead of the local memory of a…
- A.
To speed up context swithces roll in/roll out
- B.
To decrease the size of the work processes local memory
- C.
To prevent buffer swaps
- D.
To prevent operating system paging
Correct Answer
A. To speed up context swithces roll in/roll outExplanation
Parts of user contexts are stored in extended memory instead of local memory in order to speed up context switches roll in/roll out. Context switches occur when the operating system needs to switch from one process to another, and it involves saving the current process's state and loading the state of the next process. By storing parts of the user contexts in extended memory, the system can quickly roll in and roll out the necessary context information during context switches, reducing the time required for these switches and improving overall system performance.Rate this question:
-
- 27.
What is the most likely cause for a high wait time in a system?
- A.
Insufficient number of free work processes
- B.
Sap buffers (program, cua, or screen) are too small
- C.
Cpu bottlenecks
- D.
Not enough extended memory or space in the roll buffer available
Correct Answer
A. Insufficient number of free work processesExplanation
A high wait time in a system is most likely caused by an insufficient number of free work processes. When there are not enough work processes available, tasks have to wait in a queue before they can be executed, resulting in increased wait time. This can slow down the overall system performance as tasks are delayed and resources are not efficiently utilized. Increasing the number of free work processes can help alleviate this issue and improve system responsiveness.Rate this question:
-
- 28.
Which response time elements that are displayed in the transaction workload monitor st03n 3 OPTIONS
- A.
Cpu time
- B.
Processing time
- C.
Roll in time
- D.
Enqueue time
- E.
Database request time
Correct Answer(s)
A. Cpu time
B. Processing time
E. Database request timeExplanation
The transaction workload monitor st03n displays three response time elements: CPU time, processing time, and database request time. CPU time refers to the amount of time the CPU spends executing a transaction. Processing time is the total time taken by the system to process a transaction, including CPU time, I/O time, and wait time. Database request time is the time taken by the database to process a transaction, including the time spent on disk I/O and data retrieval. These three elements provide insights into the performance and efficiency of the system during transaction processing.Rate this question:
-
- 29.
You suspect there is an issue with the network connection from the application layer. Which check do you perform in which transaction?
- A.
Check cursor cache ins transaction dba cockpit dbacockpit
- B.
Trace, in transaction single transaction analysis st12
- C.
Connection test in work process overview sm50/sm66
- D.
Lan check by ping in transaction operating system monitor st06n
Correct Answer
D. Lan check by ping in transaction operating system monitor st06nExplanation
In order to determine if there is an issue with the network connection from the application layer, you would perform a LAN check by using the ping command in the transaction operating system monitor (transaction code ST06N). This transaction allows you to monitor the network performance and check the connectivity between the application layer and the network. By using the ping command, you can send a test signal to a specific IP address or hostname and check if there is a response. This helps to diagnose any network connectivity issues that may be affecting the application layer.Rate this question:
-
- 30.
Where and when is abap heap memory allocated
- A.
In the local memory of the work process, when the work process is started
- B.
In the local memory of the work process, when required
- C.
In shared memory, when required
- D.
In shared memory when the system is started
Correct Answer
B. In the local memory of the work process, when requiredExplanation
Abap heap memory is allocated in the local memory of the work process when it is required. This means that the memory is not allocated at the start of the work process, but rather when it is needed during the execution of the program. This allows for efficient memory management, as memory is only allocated when necessary and can be released when no longer needed. By allocating the memory in the local memory of the work process, it ensures that each work process has its own dedicated memory space for storing and processing data.Rate this question:
-
- 31.
In transaction workload monitor st03n you see that dialog work processes have high average… what is the most likely reason for this issue?
- A.
An insufficient size of sap buffers
- B.
A cpu bottleneck
- C.
An insufficient number of free work processes
- D.
A memory bottleneck on the database server
Correct Answer
A. An insufficient size of sap buffersExplanation
The most likely reason for the high average of dialog work processes in the transaction workload monitor st03n is an insufficient size of SAP buffers. SAP buffers are used to store frequently accessed data in memory, allowing for faster access and reducing the workload on the database server. If the buffer size is insufficient, it can lead to increased workload on the dialog work processes as they have to retrieve data from the database more frequently, resulting in higher average values.Rate this question:
-
- 32.
Which buffering types are available in sap table buffers? 2 OPTIONS
- A.
Definition only buffered
- B.
Partially buffered
- C.
Fully buffered
- D.
Single record buffered
Correct Answer(s)
C. Fully buffered
D. Single record bufferedExplanation
The available buffering types in SAP table buffers are fully buffered and single record buffered. Fully buffered means that the entire table is loaded into the buffer, allowing for fast access to all records. Single record buffered means that only one record at a time is loaded into the buffer, which can be useful for tables with a large number of records where memory constraints may be an issue.Rate this question:
-
- 33.
In transaction profile of transaction workload monitor st03n, how do you identify a p… 2 OPTIONS
- A.
Its average cpu time and or database time are high
- B.
Its average cpu time is greater than the average processing time
- C.
Its number of steps is very low
- D.
Its total response time and average response time are high
Correct Answer(s)
A. Its average cpu time and or database time are high
B. Its average cpu time is greater than the average processing timeExplanation
The correct answer suggests that in the transaction profile of the transaction workload monitor st03n, a transaction can be identified as a problem if its average CPU time and/or database time are high. Additionally, if the average CPU time is greater than the average processing time, it can also indicate an issue with the transaction. This implies that high CPU and database usage can be indicators of performance problems in a transaction.Rate this question:
-
- 34.
In transaction operating system monitors st06n you detect that cpu idle value on a server… whow should you investigate this situation 2 OPTIONS
- A.
Perform a detailed analysis of the memory configuration of the sap system
- B.
Check if load can be distributed to other servers with spare cpu capacity
- C.
Check that there are enough dialog work processes configured on the instances on that
- D.
Check the top 40 cpu processes in transaction operating system monitor st06n
Correct Answer(s)
B. Check if load can be distributed to other servers with spare cpu capacity
D. Check the top 40 cpu processes in transaction operating system monitor st06nExplanation
The correct answer suggests two possible actions to investigate the situation. First, checking if the load can be distributed to other servers with spare CPU capacity can help identify if the current server is overloaded and if redistributing the workload can alleviate the issue. Second, checking the top 40 CPU processes in the transaction operating system monitor ST06N can provide insights into which processes are consuming the most CPU resources, allowing for further investigation and optimization if necessary.Rate this question:
-
- 35.
In transaction op system monitor st067n in an abap-only system, how can you… 2 OPTIONS
- A.
In a unit system, more than 20% of ram paged out/swapped out per hour
- B.
In a windows system, more than 20% of ram paged out per hour
- C.
In a windows system more than 25% of ram paged in per hour
- D.
In a unix system, more than 20% of ram paged in/swapped in per hour
Correct Answer(s)
A. In a unit system, more than 20% of ram paged out/swapped out per hour
C. In a windows system more than 25% of ram paged in per hourExplanation
The explanation for the given correct answer is that in a unit system, if more than 20% of RAM is paged out or swapped out per hour, it indicates that the system is experiencing a high level of memory pressure and is struggling to keep up with the demand for memory. Similarly, in a Windows system, if more than 25% of RAM is paged in per hour, it suggests that the system is constantly bringing data into memory from disk, which can also indicate memory pressure. Both scenarios indicate potential performance issues and the need for further investigation and optimization.Rate this question:
-
- 36.
What is an expensive sql statement?
- A.
An sql statement that causes the database to read many blocks from disk or database
- B.
An sql statement that does not use the best possible access path
- C.
An sql statement that cannot be tuned by implementing database related changers
- D.
An sql statement that causes the db to read more blocks
Correct Answer
A. An sql statement that causes the database to read many blocks from disk or databaseExplanation
An expensive SQL statement refers to a statement that requires the database to read a large number of blocks from disk or database. This indicates that the statement is inefficient and can potentially slow down the performance of the database. It suggests that the query is not optimized and may need to be tuned to improve its execution time and resource usage. By reducing the number of blocks read, the statement can be made more efficient and improve overall database performance.Rate this question:
-
- 37.
A customer complains that a particular transaction performs badly, which of the following transactions can you use to investigate the performance details
- A.
Sap workload business transaction analysis stad
- B.
Work process overview sm50 and sm66
- C.
Workload monitor st03n
- D.
Sql trace st05 or st12
Correct Answer
C. Workload monitor st03nExplanation
The correct answer is "Workload monitor st03n." The workload monitor st03n is a transaction that can be used to investigate the performance details of a particular transaction. It provides information about the workload of the system, including response times, database performance, and resource usage. By analyzing the data provided by the workload monitor, it is possible to identify any performance issues and take appropriate actions to resolve them.Rate this question:
-
- 38.
How can expensive sql statement cause poor performance of other programs? 3 OPTIONS
- A.
By causing other pricesses to wait for db and or work processes which are..
- B.
By displacing many blocks from the sap buffers that must..
- C.
By creating a hardware bottleneck on the db server
- D.
By causing missing optimiser stats that cause other processes choose incorrect actions
- E.
By displacing many blocks from the database buffer must be replaced by other processes
Correct Answer(s)
A. By causing other pricesses to wait for db and or work processes which are..
C. By creating a hardware bottleneck on the db server
D. By causing missing optimiser stats that cause other processes choose incorrect actionsExplanation
Expensive SQL statements can cause poor performance of other programs by causing them to wait for database and/or work processes. This is because the resources needed for these processes are being utilized by the expensive SQL statement, leading to delays and reduced performance for other programs. Additionally, the expensive SQL statement can create a hardware bottleneck on the database server, further impacting the performance of other programs. Furthermore, if the expensive SQL statement causes missing optimizer statistics, it can result in other processes making incorrect decisions, leading to poor overall performance.Rate this question:
-
- 39.
What are potential tuning measure for the icm? 2 OPTIONS
- A.
Configure the internet server cache of the icm
- B.
Identify expelsive sql statement via icm monitor
- C.
Adjust the number of icm worker thread and connections
- D.
Make us of the icm parameter rsdb/disable_memory_pipes
Correct Answer(s)
A. Configure the internet server cache of the icm
C. Adjust the number of icm worker thread and connectionsExplanation
The potential tuning measures for the icm include configuring the internet server cache of the icm, which can help improve performance by caching frequently accessed content. Additionally, adjusting the number of icm worker threads and connections can optimize resource allocation and improve overall system throughput.Rate this question:
-
Back to top