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.
Answer: D
Explanation:
References:
https://www.itprotoday.com/microsoft-sql-server/top-10-sql-server-performance-tuning-tips