Posted by: Pdfprep
Post Date: November 20, 2020
You have Microsoft SQL Server on a DS-series Microsoft Azure virtual machine. The virtual machine has a production database named DB1. All database files are on drive E and use standard storage.
Users report that queries take a long time to execute.
You discover that the queries are waiting for pagelatch_IO.
You need to reduce the amount of time it takes for the queries to execute.
What should you do?
A . Move the databases for DB1 to drive
C . On drive E add more database files for DB
E . Move the msdb databases to drive
G . Change drive E to Premium Storage.
Answer: B
Leave a Reply