A user is complaining about slowness of a mission-critical MSSQL Server. The administrator logs into Prism Element to investigate the VM performance and observes what is shown in the diagram.
Which action would best improve VM performance?
A.
Disable hyperthreading in the BIOS.
B.
Add additional RAM to the user VM.
C.
Add additional RAM to the host on which the VM is running.
D.
Ensure the host's CPUs ere not excessively overcommitted.
Prism Element is a graphical user interface that allows you to manage Nutanix clusters1. You can use Prism Element charts to understand Nutanix cluster workloads and troubleshoot performance related issues2.
memory optimized virtual machine sizes offer the best performance for SQL Server workloads on Azure VMs. Adding more RAM to the user VM can help reduce paging and improve query execution times.
SQL Server performance can be affected by disk latency and throughput. By creating separate virtual disks for data and logs, you can spread activity across multiple spindles and reduce disk contention.
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit