Exercise 1: Isolate problems by monitoring

Please verify that the code has been copied correctly, with the proper line breaks, before executing the code. Note: The exercises ask you to copy and paste T-SQL code. You need to use the Azure portal as well as on-premises tools to identify the performance issues and suggest methods to resolve them. Recently the company has noticed performance degradation within both products that are used to service customer requests. The company utilizes a mixture of both Azure SQL Databases as well as a SQL Server in an Azure Virtual Machine. AdventureWorks has been selling bicycles and bicycle parts directly to consumers and distributors for over a decade. You have been hired as a database administrator to identify performance related issues and provide viable solutions to resolve any issues found. Utilize query store to locate & resolve blocking issues by creating a new index Isolate performance problems through monitoring.

Lab objectivesĪfter completing this lab, you will be able to: Finally, students will be able to identify fragmentation within the database as well as learn steps to resolve the issue appropriately. Examining the Azure portal as well as other tools, students will determine how to utilize native tools to identify and resolve performance related issues. The students will take the information gained in the lessons to scope out the deliverables for a digital transformation project within AdventureWorks. Pre-requisites: Lab VM, and Azure SQL Database created in Labs 2 and 3 Lab overview Monitor and Optimize Operational Resources

N lab master