You have Microsoft SQL Server on a DS-series Microsoft Azure virtual machine. The virtual machine has 28 GB of memory.
You discover the following performance statistics on the server:
The average Page life expectancy is 30.
The server has excessive PAGELATCH_IO waits.
You need to decrease the PAGELATCH_IO waits.
What should you do?
A. Enable large-page support.
B. Enable lock pages in memory.
C. Configure buffer pool extensions.
D. Add more tempdb files.
