Manage database workload in SQL ServerDesign and implement Elastic Scale for Azure SQL DatabaseSelect an appropriate service tier or editionOptimize database file and tempdb configurationOptimize memory configurationMonitor and diagnose schedule and wait statistics using dynamic management objectsTroubleshoot and analyze storage, IO, and cache issuesMonitor Azure SQL Database query plansSkill 4.4: Monitor and trace SQL Server baseline performance metricsMonitor operating system and SQL Server performance metricsCompare baseline metrics to observed metrics while troubleshooting performance issuesIdentify differences between performance monitoring and logging toolsMonitor Azure SQL Database performanceDetermine best practice use cases for extended eventsDistinguish between Extended Events targetsCompare the impact of Extended Events and SQL TraceDefine differences between Extended Events Packages, Targets, Actions, and SessionsChapter summaryThought experimentThought experiment answer