exam questions

Exam 70-762 All Questions

View all questions & answers for the 70-762 exam

Exam 70-762 topic 1 question 34 discussion

Actual exam question from Microsoft's 70-762
Question #: 34
Topic #: 1
[All 70-762 Questions]

DRAG DROP -
You are analyzing the memory usage of a Microsoft SQL Server instance.
You need to obtain the information described on the following table.

Which performance counter should you use for each requirement? To answer, drag the appropriate performance counters to the correct requirements. Each performance counter may be used once, more than once or not at all. You may need to drag the split bat between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:

Show Suggested Answer Hide Answer
Suggested Answer:
Requirement1: SQL Server: Memory Manager: Total Server Memory (KB)
This counter specifies theamount of memory the server has committed using the memory manager.
Requirement2: SQL Server: Memory Manager: Granted Workspace Memory (KB)
Specifies the total amount of memory currently granted to executing processes, such as hash, sort, bulk copy, andindex creation operations.
Requirement3: Process: working Set
Each time a process is created, it reserves the minimum working set size for the process. The virtual memory manager attempts to keep enough memory for the minimum working set resident when the process is active, but keeps no more than the maximum size.
References:
https://msdn.microsoft.com/en-us/library/ms190924.aspx
https://blogs.technet.microsoft.com/askperf/2007/05/18/sql-and-the-working-set/

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Heisenberg008
Highly Voted 5 years, 3 months ago
Second box should be Target Server Memory (KB): Indicates the ideal amount of memory the server can consume. https://docs.microsoft.com/en-us/sql/relational-databases/performance-monitor/sql-server-memory-manager-object?view=sql-server-ver15
upvoted 20 times
...
MML
Highly Voted 4 years, 10 months ago
1. Total Server Memory 2. Target Server Memory 3.Process Working Set
upvoted 14 times
...
rya
Most Recent 5 years, 3 months ago
The second box is correct. the definition of Target Server Memory (KB) does not match - Indicates the ideal amount of memory the server can consume.
upvoted 1 times
TintinDoan
4 years, 11 months ago
Actually, The Target Server Memory (KB) value shows how much memory SQL Server needs to for best performance -> matches the requirement 2.
upvoted 3 times
...
...
Jiacheng
5 years, 3 months ago
I think answer is correct
upvoted 3 times
Nickname17
5 years, 1 month ago
The second box is incorrect. the definition of Target Server Memory (KB) matches -Indicates the ideal amount of memory the server can consume.
upvoted 4 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...