~Get Your Files Here !

  Ex_Files_Microsoft_Azure_DP_300_Cert_Prep_2

   Exercise Files

  [1] Introduction

   [1] Optimize and automate Azure databases.srt

   [2] What you should know.srt

  [2] 1. Monitoring Azure Resources

   [1] Review VM performance with Azure Monitor.srt

   [2] Connect to a VM with Remote Desktop.srt

   [3] Create an automated alert.srt

   [4] Collect performance data with Azure Intelligent Insights.srt

  [3] 2. Optimizing Azure Performance

   [1] Storage configurations for Azure Virtual Machines.srt

   [2] Resizing a virtual machine.srt

   [3] Allocate resources with Resource Governor.srt

  [4] 3. Optimizing SQL Server Performance

   [1] Database-level performance options.srt

   [2] Intelligent query processing.srt

   [3] Rebuild and reorganize indexes.srt

   [4] Maintain up-to-date statistics.srt

  [5] 4. Optimizing Query Performance

   [1] Estimated and actual query plans.srt

   [2] Reading a query plan.srt

   [3] Retrieve performance data from the Query Store.srt

   [4] Leverage dynamic management views.srt

   [5] Wait statistics, locks, and blocks.srt

   [6] Automatic index tuning.srt

  [6] 5. Automate Tasks with SQL Server Agent

   [1] Create an automated maintenance plan.srt

   [2] Automate notifications and alerts.srt

   [3] Monitor queries with extended events.srt

  [7] 6. Automate Resource Deployment

   [1] Azure Resource Manager templates.srt

   [2] Create a template.srt

   [3] Deploy a template.srt

  [8] Conclusion

   [1] Next steps.srt