What should you recommend?

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. Processes for allocating tables show high latency.

You need to recommend a solution to improve performance when allocating tables.

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

View Answer

Answer: D

Explanation:

References:

https://www.itprotoday.com/microsoft-sql-server/top-10-sql-server-performance-tuning-tips