Exam 70-765 topic 4 question 15 discussion

Actual exam question from Microsoft's 70-765

Question #: 15
Topic #: 4

A company hosts a default installation of Microsoft SQL Server 2017 on a Linux-based server.
You observe that the performance of the server has degraded. Process for allocating tables show high latency.
You need to recommend a solution to improve performance when allocating tables.
What should you recommend?

A. Configure additional tempdb data files
B. Reinstall SQL Server on Linux
C. Set a memory limit for the SQL server
D. Increase the Virtual Address Space limit

Show Suggested Answer

Suggested Answer: C 🗳️
References:
https://www.itprotoday.com/microsoft-sql-server/top-10-sql-server-performance-tuning-tips

by KC at July 2, 2020, 1:45 a.m.

Comments

Submit Cancel

KC

Highly Voted 4 years, 12 months ago

Could be A: https://support.microsoft.com/en-us/help/2154845/recommendations-to-reduce-allocation-contention-in-sql-server-tempdb-d

upvoted 5 times

...

Slava_bcd81

Most Recent 4 years, 9 months ago

Difficult question, It can be C also - if there is no memory limit and there is virtual memory that is not physical memory, but disk memory - SQL Server can start use all that memory, disk memory is slow and can cause other processes to slow down if they use the same disk

upvoted 1 times

...