In this post, I have shared some quick tips, including Q/A and useful links from the Day 4 live session of our current batch of Azure Database Administrator Training Program [DP-300]. We have covered some topics like Azure metrics, Azure Monitor and optimize, and Query Store.
On our Day 3 Live Session, we have covered interesting topics like advanced threat protection, permission chains, different firewall settings, and multi-factor authentication using the azure active directory.
On our Day 4 Live Session of the [DP-300] Microsoft Database Administrator Training Program, we covered the concepts of Monitor And Optimize Operational Resources and Learned how to Monitor And Optimize Resources.
Monitor And Optimize Operational Resources
Azure offers tools for monitoring the Azure Database by using the Azure metrics tool, you may lack some specific controls around hardware that you would have in an on-premises environment which makes understanding how to identify and resolve performance bottlenecks while in Azure SQL that is much more critical. And experience using Windows Performance Monitor to monitor system components such as CPU, I/O, network traffic.
Q.1 What is a Baseline?
A baseline is a general set of metrics around performance and utilization that allow you to easily separate performance anomalies from normal usage patterns. The metrics can be as simple as CPU and Disk utilization or collect a detailed set of metrics on OS and database utilization.
Q.2 What is Azure Monitor?
- All Azure resources collect a set of metrics which are collected through the Azure Monitor service.
- Enhanced data may be collected Monitor through the Azure Monitoring Insights for virtual machine resources And data is stored in Azure Log Analytics.
Q.3 Explain Windows Performance Monitor.
This is the in tool in the Windows operating system. Performance Monitor allows you to collect detailed, granular performance data about SQL Server and Windows operations. You can group Performance Monitor counters together to easily gather and analyze performance data azure metrics. Data can be easily exported to an archive (e.g. a SQL Server database).
Q.4 What are Azure Metric Alerts?
Azure has a built-in alerting system that allows you to create alerts. These alerts can simply be notifications like email or text messages or can be automated actions like executing an Azure Function or an Azure Automation runbook. The alerts can be configured based on the azure metrics in your VM or other Azure resources. You can also configure dynamic alerts which learn the behavior of your resource and only alert on abnormal usage.
You can check out our related blog here: Create alerts for Azure SQL Managed Instance
Q.5 What are Azure SQL Database Intelligent Insights?
Azure SQL Database collects and tracks query performance data from your database captures runtime statistics and execution plan history. And data can optionally be stored in Azure Log Analytics which allows you to use the Azure SQL Analytics dashboard.
Q.6 What is Query Store?
This is the data collection tool that tracks query execution plans and runtime statistics. It will help you quickly identify queries that have regressed in performance. It is available in Azure SQL Database and Azure SQL Managed Instance it also helps in monitoring the queries with azure metrics.
Q.7 What is the Execution plan forcing?
- This feature allows you to force the database engine to use a specific execution plan for a given query.
- Plan forcing is typically used as a temporary fix for a sudden query plan regression.
- The Automatic tuning feature in Azure SQL uses this feature
Q.8 What are isolation levels?
SQL Server offers multiple isolation levels to allow for a balance of concurrency and data quality. Isolation levels are specified at the session level but may be overridden by the query. Lower isolation like reading Uncommitted may allow for more users to read the data, but increase the chance that the queries return incorrect results.
Q.9 How Many types of managed disks are offered in Azure?
There are mainly four types of managed disks are offered in azure :
Ultra Disk-Ultra disks support high-10 workloads for mission-critical databases with extremely low latency.
Premium SSD-Premium SSD disks are high-throughput and low latency and can meet the needs of most database workloads running in the cloud
Standard SSD-Standard SSDs are designed for lightly used dev/test workloads or web servers that do a small amount of IO and require predictable latency.
Standard HDD-Standard HDDs are suitable for backups and file storage that is infrequently accessed
Q.10 What is Resource Governor in SQL Server and Azure SQL Database Managed Instance?
Resource governor allows you to balance resources allocated to workloads within your SQL Server or Managed Instance. Workloads are divided into resource pools that allow you to limit CPU, memory, and IOPS for user sessions. Workloads are classified using a classifier function that can identify the session by metadata and assign it to a specific resource pool.
Q.11 What is Automatic Tuning?
Automatic tuning is a database feature that provides insight into potential query performance problems, recommends solutions, and automatically monitoring and fix identified problems.
>Lab: Monitor and Optimize Resources
In this lab, we will learn to determine how to utilize native tools to identify and resolve performance and monitoring-related issues. And to identify fragmentation within the database as well as learn steps to resolve the issue appropriately.And how to use the Azure Metrics.
Feedback Received…
Here is some positive feedback from our trainees who attended the session:
Read more about the DP-300 Certification and whether it is the right certification for you, from our blog on Exam DP-300: Microsoft Azure Database Administrator Associate
Quiz Time (Sample Exam Questions)!
With our Azure Database Administrator Training Program, we cover 200+ sample exam questions to help you prepare for the DP-300 Certification.
Ques: Your company has a set of Azure SQL Databases as part of its Azure subscription. You have to apply 10 in-built Azure policies to both existing and new Azure SQL Databases. The solution must minimize administrative effort. Which of the following would you implement for this requirement? Choose 3 answers from the options given below.
A. Duplicate the Azure Policy definitions
B. Run Azure Policy remediation tasks
C. Create an Azure Blueprints assignment
D. Create an Azure policy initiative
E. Create an Azure Policy assignment
Comment with your answer & we will tell you if you are correct or not!
Next Task For You
Begin your journey toward Mastering Azure Cloud and landing high-paying jobs. Just click on the register now button on the below image to register for a Free Class on Mastering Azure Cloud: How to Build In-Demand Skills and Land High-Paying Jobs. This class will help you understand better, so you can choose the right career path and get a higher paying job.
Leave a Reply