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 a report that runs against a Microsoft Azure SQL database.The report takes more time to return results than expected.You add an index to a table in the database.You need to identify whether adding the index improves the performance issue. What should you use?
You have Microsoft SQL Server installed on a Microsoft Azure virtual machine named VM1. VM1 is provisioned by using the classic deployment model and is on the Standard GS5 service tier.The virtual machine is used for testing purposes only.You need to minimize the costs associated with VM1 when the virtual machine is unused.Which command should you use?
You have several SQL Server instances on Microsoft Azure virtual machines.Periodically, one of the virtual machines runs more slowly than expected. The issue typically persists for up to 30 minutes. You investigate the issue and discover that when the issue occurs, there is high CPU usage on the virtual machines.You need to be notified automatically when the performance issue occurs. You want to achieve this goal by using the minimum amount of administrative effort.What should you configure?
You have Microsoft SQL Server 2014 installed on a Microsoft Azure virtual machine.One of the databases on the virtual machine supports a highly active Online Transaction Processing (OLTP) application. Users report abnormally long wait times when they submit data in the application.Which two tools can you use to identify the longest running queries? Each correct answer presents a complete solution.
DRAG DROP -You have several instances of Microsoft SQL Server on several Microsoft Azure virtual machines.You need to implement an automated process to back up all of the virtual machines to an Azure storage account. The process must run weekly.Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.Select and Place:
