C_TADM53_70 · Question #17
The attached figure shows the first screen of the SQL Server Performance Analysis transaction (ST04). To tune the SQL Server performance, you need to interpret the information displayed on this…
The correct answer is A. 'SQL Memory Setting' = AUTO (note: not shown in the figure, but possible) allows the SQL Server B. The size of the procedure cache ('Proc. Cache (MB)') is always determined by the SQL Server E. 'SQL Memory Setting' = RANGE allows the SQL Server to allocate memory dynamically. See the full explanation below for the reasoning.
Question
The attached figure shows the first screen of the SQL Server Performance Analysis transaction (ST04). To tune the SQL Server performance, you need to interpret the information displayed on this screen correctly and possibly change some of the SQL Server settings. Which interpretations are valid and which actions should be taken? (Choose three)
Options
- A'SQL Memory Setting' = AUTO (note: not shown in the figure, but possible) allows the SQL Server
- BThe size of the procedure cache ('Proc. Cache (MB)') is always determined by the SQL Server
- C'CPUs used by MSS' is determined by the SQL Server configuration parameter affinity I/O mask.
- D'Phys. Memory (MB)' is the amount of physical memory assigned to the SQL Server instance.
- E'SQL Memory Setting' = RANGE allows the SQL Server to allocate memory dynamically.
How the community answered
(35 responses)- A80% (28)
- C6% (2)
- D14% (5)
Community Discussion
No community discussion yet for this question.