PdfPrep.com

What should you do?

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

Exit mobile version