ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-765 All Questions

View all questions & answers for the 70-765 exam
Go to Exam

Exam 70-765 topic 4 question 18 discussion

Actual exam question from Microsoft's 70-765
Question #: 18
Topic #: 4
[All 70-765 Questions]

You have Microsoft SQL server on a Microsoft Azure virtual machine. The virtual machine has 200 GB of data.
User report a slow response time when querying the database.
You need to identify whether the storage subsystem causes the performance issue.
Which performance monitor counter should you view?

  • A. Data sec/Write
  • B. Avg.disk Read Queue Length
  • C. % Disk Read Time
  • D. Disk sec/Read
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by DudeHere at April 12, 2020, 10:52 a.m.

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
Submit Cancel
Cococo
4 years, 5 months ago
Looks like D, check the Exam Reference book. B is not valid in case of shared space like SAN or VM - https://www.sqlshack.com/bi-performance-counter-avg-disk-queue-length/
upvoted 2 times
...
MelKr
4 years, 11 months ago
Actually, disk_queue_length by itself does not give any relevant information only that the disk is busy but not how busy actually. We would need to know the number of physical disks to judge if the value is too high. You should measuer "Disk sec/Read" which is independent of underlying hardware and gives you a good measure for IO-performance. see: https://www.mssqltips.com/sqlservertip/2460/perfmon-counters-to-identify-sql-server-disk-bottlenecks/
upvoted 3 times
jolsca
4 years, 7 months ago
Is correct D
upvoted 2 times
...
Slava_bcd81
4 years, 7 months ago
B, If disk have a queue it means it slows down the system, no options
upvoted 1 times
Slava_bcd81
4 years, 7 months ago
If where was kind of "I/O priority setup" that would give SQL Server processes high I/O priority - that would mitigate that issue, but I never heard about such option
upvoted 1 times
...
...
...
DudeHere
5 years ago
B. https://www.sciencedirect.com/topics/computer-science/disk-queue-length
upvoted 3 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago