You need to resolve the performance issues

You have Microsoft SQL Server installed on a Microsoft Azure virtual machine. The virtual machine is on the
Standard D3 service tier. All of the data files for the databases on the virtual machine are located on a single
volume that is mounted as drive E.
The virtual machine experiences performance issues.
You view the wait statistics and discover a high number of РАGEIOLATCH_SH waits associated to the tempdb
data files.
You need to resolve the performance issues.
What should you do?

You have Microsoft SQL Server installed on a Microsoft Azure virtual machine. The virtual machine is on the
Standard D3 service tier. All of the data files for the databases on the virtual machine are located on a single
volume that is mounted as drive E.
The virtual machine experiences performance issues.
You view the wait statistics and discover a high number of РАGEIOLATCH_SH waits associated to the tempdb
data files.
You need to resolve the performance issues.
What should you do?

A.
Move the tempdb data files to drive D.

B.
Move the tempdb data files to drive C.

C.
Change the servicetier of the virtual machine to Standard D12.

D.
Change the service tier of the virtual machine to Standard DS3.



Leave a Reply 1

Your email address will not be published. Required fields are marked *