We may earn an affiliate commission when you visit our partners.
Azure SQL Database
Diagnosing Performance Issues with DMVs
Glenn Berry
Glenn Berry
Learn how to easily query Azure SQL Database for performance and configuration information to help identify and fix issues that can affect performance and stability. This course is applicable to anyone responsible for Azure SQL Database.
Read more
Learn how to easily query Azure SQL Database for performance and configuration information to help identify and fix issues that can affect performance and stability. This course is applicable to anyone responsible for Azure SQL Database.
Read more
Learn how to easily query Azure SQL Database for performance and configuration information to help identify and fix issues that can affect performance and stability. This course is applicable to anyone responsible for Azure SQL Database.
It is very common for Azure SQL Databases to have workload performance problems. In this course, Azure SQL Database: Diagnosing Performance Issues with DMVs, you will learn how to use a variety of DMV queries to find performance and configuration information in Azure SQL Database. First, you will see how to diagnose and fix configuration issues at the database level. Next, you will discover how to diagnose and fix performance issues related to CPU and workload activity. Finally, you will explore how to find and fix issues related to storage and memory. When you are finished with this course, you will have the skills and knowledge to use these DMV queries to increase the performance and stability of your workload on Azure SQL Database.
Register for this course and see more details by visiting:
OpenCourser.com/course/qdy137/azure
What's inside
Syllabus
Course Overview
Introduction
Diagnosing Database-level Configuration Issues
Diagnosing CPU-related Issues
Read more
Syllabus
Course Overview
Introduction
Diagnosing Database-level Configuration Issues
Diagnosing CPU-related Issues
Read more
Diagnosing Activity-related Issues
Diagnosing Storage and Memory-related Issues
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Helps identify and fix issues that affect performance of Azure SQL Database with DMV queries
Taught by Glenn Berry, an expert in Azure SQL Database
Applicable to anyone managing Azure SQL Database
Covers diagnosing database-level configuration issues, CPU-related issues, activity-related issues, and storage and memory-related issues
Save this course
Save Azure SQL Database: Diagnosing Performance Issues with DMVs to your list so you can find it easily later:
Save
Save
Activities
Be better prepared
before
your course. Deepen your understanding
during
and
after
it. Supplement your coursework and achieve mastery of the topics covered
in Azure SQL Database: Diagnosing Performance Issues with DMVs with these
activities:
Review SQL Fundamentals
Show steps
Brush up on SQL concepts to strengthen your foundation for this course.
Browse courses on
Azure SQL Database
Show steps
-
Review online tutorials or articles
-
Take practice quizzes or tests
Join a Study Group
Show steps
Collaborate with peers to discuss concepts, share experiences, and solve problems.
Show steps
-
Find or form a study group
-
Participate in regular study sessions
Explore Azure SQL Database Performance Best Practices
Show steps
Become familiar with best practices for optimizing performance on Azure SQL Database.
Browse courses on
Performance Optimization
Show steps
-
Read Microsoft documentation and articles
-
Attend webinars or workshops
Four other activities
Expand to see all activities and additional details
Show all seven activities
Practice SQL Queries
Show steps
Build proficiency in writing SQL queries by practicing on Azure SQL Database.
Browse courses on
SQL
Show steps
-
Create a practice database
-
Write queries to retrieve performance and configuration data
-
Analyze the results and identify potential issues
Attend Azure SQL Database Performance Workshop
Show steps
Gain hands-on experience and learn from experts in Azure SQL Database performance.
Browse courses on
Azure SQL Database
Show steps
-
Find and register for a workshop
-
Prepare for and attend the workshop
-
Practice and apply what you learned
Write a Blog Post on Azure SQL Database Performance
Show steps
Deepen your understanding by explaining performance issues and solutions to others.
Browse courses on
Technical Writing
Show steps
-
Research and gather information
-
Outline and draft the content
-
Proofread and publish the blog post
Configure Azure SQL Database for Optimal Performance
Show steps
Apply your knowledge by configuring a database for optimal performance.
Browse courses on
Performance Optimization
Show steps
-
Identify performance bottlenecks and areas for improvement
-
Implement configuration changes based on best practices
-
Monitor and evaluate the impact of the changes
Review SQL Fundamentals
Show steps
Brush up on SQL concepts to strengthen your foundation for this course.
Browse courses on
Azure SQL Database
Show steps
Show steps
Show steps
- Review online tutorials or articles
- Take practice quizzes or tests
Join a Study Group
Show steps
Collaborate with peers to discuss concepts, share experiences, and solve problems.
Show steps
Show steps
Show steps
- Find or form a study group
- Participate in regular study sessions
Explore Azure SQL Database Performance Best Practices
Show steps
Become familiar with best practices for optimizing performance on Azure SQL Database.
Browse courses on
Performance Optimization
Show steps
Show steps
Show steps
- Read Microsoft documentation and articles
- Attend webinars or workshops
Four other activities
Expand to see all activities and additional details
Show all seven activities
Practice SQL Queries
Show steps
Build proficiency in writing SQL queries by practicing on Azure SQL Database.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Create a practice database
- Write queries to retrieve performance and configuration data
- Analyze the results and identify potential issues
Attend Azure SQL Database Performance Workshop
Show steps
Gain hands-on experience and learn from experts in Azure SQL Database performance.
Browse courses on
Azure SQL Database
Show steps
Show steps
Show steps
- Find and register for a workshop
- Prepare for and attend the workshop
- Practice and apply what you learned
Write a Blog Post on Azure SQL Database Performance
Show steps
Deepen your understanding by explaining performance issues and solutions to others.
Browse courses on
Technical Writing
Show steps
Show steps
Show steps
- Research and gather information
- Outline and draft the content
- Proofread and publish the blog post
Configure Azure SQL Database for Optimal Performance
Show steps
Apply your knowledge by configuring a database for optimal performance.
Browse courses on
Performance Optimization
Show steps
Show steps
Show steps
- Identify performance bottlenecks and areas for improvement
- Implement configuration changes based on best practices
- Monitor and evaluate the impact of the changes
Career center
Learners who complete Azure SQL Database: Diagnosing Performance Issues with DMVs will develop knowledge and skills
that may be useful to these careers:
Database Administrator
Database Administrator
Database Administrators are responsible for the performance and stability of an organization's databases. In this role, you will use your knowledge of Azure SQL Database to ensure that your organization's databases are running efficiently. You will also be responsible for diagnosing and fixing any performance issues that may arise. This course will help you build a strong foundation in Azure SQL Database, which will be essential for success in this role.
Data Analyst
Data Analyst
Data Analysts are responsible for collecting, analyzing, and interpreting data to help organizations make better decisions. In this role, you will use your knowledge of Azure SQL Database to query and analyze data to identify trends and patterns. You will also be responsible for presenting your findings to stakeholders in a clear and concise manner. This course will help you develop the skills you need to be successful in this role, including how to write efficient queries and how to interpret data.
Data Engineer
Data Engineer
Data Engineers are responsible for designing, building, and maintaining data pipelines. In this role, you will use your knowledge of Azure SQL Database to create and manage data pipelines that move data from source systems to target systems. You will also be responsible for ensuring that data pipelines are efficient and reliable. This course will help you develop the skills you need to be successful in this role, including how to design and build data pipelines and how to monitor and troubleshoot data pipelines.
Software Engineer
Software Engineer
Software Engineers are responsible for designing, developing, and maintaining software applications. In this role, you will use your knowledge of Azure SQL Database to develop applications that interact with databases. You will also be responsible for ensuring that applications are efficient and reliable. This course will help you develop the skills you need to be successful in this role, including how to write efficient code and how to debug code.
Cloud Architect
Cloud Architect
Cloud Architects are responsible for designing and implementing cloud solutions. In this role, you will use your knowledge of Azure SQL Database to design and implement cloud solutions that meet the needs of your organization. You will also be responsible for ensuring that cloud solutions are efficient and reliable. This course will help you develop the skills you need to be successful in this role, including how to design and implement cloud solutions and how to monitor and troubleshoot cloud solutions.
Business Analyst
Business Analyst
Business Analysts are responsible for analyzing business processes and identifying opportunities for improvement. In this role, you will use your knowledge of Azure SQL Database to analyze data and identify opportunities to improve business processes. You will also be responsible for presenting your findings to stakeholders in a clear and concise manner. This course will help you develop the skills you need to be successful in this role, including how to write efficient queries and how to interpret data.
Project Manager
Project Manager
Project Managers are responsible for planning, executing, and closing projects. In this role, you will use your knowledge of Azure SQL Database to manage projects that involve the use of Azure SQL Database. You will also be responsible for ensuring that projects are completed on time, within budget, and to the satisfaction of stakeholders. This course will help you develop the skills you need to be successful in this role, including how to plan and execute projects and how to manage stakeholders.
Database Developer
Database Developer
Database Developers are responsible for designing and developing databases. In this role, you will use your knowledge of Azure SQL Database to design and develop databases that meet the needs of your organization. You will also be responsible for ensuring that databases are efficient and reliable. This course will help you develop the skills you need to be successful in this role, including how to design and develop databases and how to monitor and troubleshoot databases.
Data Scientist
Data Scientist
Data Scientists are responsible for using data to solve business problems. In this role, you will use your knowledge of Azure SQL Database to query and analyze data to identify patterns and trends. You will also be responsible for developing and implementing machine learning models to solve business problems. This course will help you develop the skills you need to be successful in this role, including how to write efficient queries and how to interpret data.
IT Manager
IT Manager
IT Managers are responsible for managing the IT infrastructure of an organization. In this role, you will use your knowledge of Azure SQL Database to manage the organization's Azure SQL Database infrastructure. You will also be responsible for ensuring that the Azure SQL Database infrastructure is efficient and reliable. This course will help you develop the skills you need to be successful in this role, including how to manage Azure SQL Database infrastructure and how to monitor and troubleshoot Azure SQL Database infrastructure.
Cloud Engineer
Cloud Engineer
Cloud Engineers are responsible for designing, implementing, and maintaining cloud infrastructure. In this role, you will use your knowledge of Azure SQL Database to design and implement cloud infrastructure that meets the needs of your organization. You will also be responsible for ensuring that cloud infrastructure is efficient and reliable. This course will help you develop the skills you need to be successful in this role, including how to design and implement cloud infrastructure and how to monitor and troubleshoot cloud infrastructure.
Systems Administrator
Systems Administrator
Systems Administrators are responsible for managing the operating systems and hardware of an organization. In this role, you will use your knowledge of Azure SQL Database to manage the operating systems and hardware that support Azure SQL Database. You will also be responsible for ensuring that operating systems and hardware are efficient and reliable. This course will help you develop the skills you need to be successful in this role, including how to manage operating systems and hardware and how to monitor and troubleshoot operating systems and hardware.
Network Administrator
Network Administrator
Network Administrators are responsible for managing the networks of an organization. In this role, you will use your knowledge of Azure SQL Database to manage the networks that connect to Azure SQL Database. You will also be responsible for ensuring that networks are efficient and reliable. This course will help you develop the skills you need to be successful in this role, including how to manage networks and how to monitor and troubleshoot networks.
Security Engineer
Security Engineer
Security Engineers are responsible for protecting the IT infrastructure of an organization. In this role, you will use your knowledge of Azure SQL Database to protect the organization's Azure SQL Database infrastructure. You will also be responsible for ensuring that the Azure SQL Database infrastructure is secure and compliant. This course will help you develop the skills you need to be successful in this role, including how to protect Azure SQL Database infrastructure and how to monitor and troubleshoot Azure SQL Database infrastructure.
Data Warehouse Manager
Data Warehouse Manager
Data Warehouse Managers are responsible for managing the data warehouses of an organization. In this role, you will use your knowledge of Azure SQL Database to manage the organization's Azure SQL Database data warehouse. You will also be responsible for ensuring that the Azure SQL Database data warehouse is efficient and reliable. This course will help you develop the skills you need to be successful in this role, including how to manage Azure SQL Database data warehouses and how to monitor and troubleshoot Azure SQL Database data warehouses.
For more career information including salaries, visit:
OpenCourser.com/course/qdy137/azure
Reading list
We've selected eight books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
Azure SQL Database: Diagnosing Performance Issues with DMVs.
Provides a detailed explanation of how SQL Server execution plans work, and how to use them to improve the performance of your queries. It valuable resource for anyone who wants to gain a deeper understanding of how SQL Server works.
Provides a detailed overview of the internal workings of SQL Server, covering topics such as query processing, storage management, and concurrency control. It valuable resource for anyone who wants to gain a deeper understanding of how SQL Server works.
Save
Provides a comprehensive overview of SQL Server diagnostics, covering topics such as performance monitoring, troubleshooting, and error handling. It valuable resource for anyone who is responsible for managing SQL Server databases.
Provides a comprehensive overview of SQL Server query performance tuning techniques. It valuable resource for anyone who wants to improve the performance of their SQL Server databases.
Provides a comprehensive overview of SQL Server execution plan optimization techniques. It valuable resource for anyone who wants to improve the performance of their SQL Server databases.
Provides a comprehensive overview of SQL Server data warehousing techniques. It valuable resource for anyone who wants to learn how to design and implement a data warehouse using SQL Server.
Provides a comprehensive overview of SQL Server BI solutions. It valuable resource for anyone who wants to learn how to design and implement a BI solution using SQL Server.
Provides a comprehensive overview of SQL Server administration tasks. It valuable resource for anyone who is responsible for managing SQL Server databases.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/qdy137/azure
Share
Similar courses
Here are nine courses similar to
Azure SQL Database: Diagnosing Performance Issues with DMVs.
SQL Server 2017: Diagnosing Configuration Issues with DMVs
OpenCourser.com/course/b5j474/sql
SQL Server 2017: Diagnosing Configuration Issues with DMVs
Most relevant
SQL Server 2017: Diagnosing Performance Issues with DMVs
OpenCourser.com/course/8mkyhb/sql
SQL Server 2017: Diagnosing Performance Issues with DMVs
Most relevant
SQL Server: Scaling SQL Server 2012 and 2014: Part 2
OpenCourser.com/course/bfrjcd/sql
SQL Server: Scaling SQL Server 2012 and 2014: Part 2
Most relevant
Managing SQL Server Database Performance
OpenCourser.com/course/vtzx0x/managing
Managing SQL Server Database Performance
Most relevant
SQL Server: Installing and Configuring SQL Server 2016
OpenCourser.com/course/pz05gx/sql
SQL Server: Installing and Configuring SQL Server 2016
Most relevant
Microsoft Azure Developer: Performing Data Integrity Testing
OpenCourser.com/course/70utty/microsoft
Microsoft Azure Developer: Performing Data Integrity...
Most relevant
What Every Developer Should Know About SQL Server Performance
OpenCourser.com/course/k3q8w4/what
What Every Developer Should Know About SQL Server...
Most relevant
Managing Azure SQL Database for the SQL Server DBA
OpenCourser.com/course/xiwpeg/managing
Managing Azure SQL Database for the SQL Server DBA
Most relevant
Managing SQL Server Database Maintenance
OpenCourser.com/course/b8mtra/managing
Managing SQL Server Database Maintenance
Most relevant
Time
90 hours
Level
Intermediate
Via
Pluralsight
Instructor
Glenn Berry
Language
English
Good to know
Helps identify and fix issues that affect performance of Azure SQL Database with DMV queries
Taught by Glenn Berry, an expert in Azure SQL Database
Applicable to anyone managing Azure SQL Database
Covers diagnosing database-level configuration issues, CPU-related issues, activity-related issues, and storage and memory-related issues
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2024 OpenCourser