What should you do?

You have Microsoft SQL Server on a Microsoft Azure virtual machine.

You discover that queries take longer than expected to execute. You also discover that the top wait type for the SQL Server instance is ASYNC_ETWORKJO.

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.

View Answer

Answer: D