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.
  Discussion forum

Question
0

Leave an answer