Exam 70-765 topic 4 question 31 discussion

Actual exam question from Microsoft's 70-765

Question #: 31
Topic #: 4

You have Microsoft SQL Server on a Microsoft Azure virtual machine.
You discover that queries take longer than expected to execute. You also find that the top wait type for the SQL Server instance is ASYNC_NETWORK_IO.
You need to resolve the performance issue.
What should you do?

A. Increase the number of processor cores for the virtual machine
B. Create any missing indexes
C. Modify the application code to remove row-by-row processing
D. Allocate more memory to the SQL Server instance

Show Suggested Answer

Suggested Answer: B 🗳️
References:
https://www.sqlservercentral.com/articles/speeding-up-data-access-part-1-missing-indexes-1

by cmps at May 20, 2020, 7:40 a.m.

Comments

Submit Cancel

cmps

Highly Voted 5 years, 2 months ago

Correct is C. The most common reason for excessive SQL Server ASYNC_NETWORK_IO wait types is that the application cannot process the data that arrives from SQL Server fast enough Row by Agonizing Row (RBAR) processing is often the cause of such behavior and high ASYNC_NETWORK_IO wait type values

upvoted 12 times

jolsca

4 years, 10 months ago

Is correct https://www.sqlshack.com/reducing-sql-server-async_network_io-wait-type/

upvoted 1 times

...