We may earn an affiliate commission when you visit our partners.
Gail Shaw
Poor database performance is a widespread problem. This course will show you how SQL Server 2016's Query Store makes solving many query performance problems much easier than before.
Read more
Poor database performance is a widespread problem. This course will show you how SQL Server 2016's Query Store makes solving many query performance problems much easier than before.
Read more
Poor database performance is a widespread problem. This course will show you how SQL Server 2016's Query Store makes solving many query performance problems much easier than before.
Poor database performance is a widespread problem, and as data volumes increase it's only going to get worse. Up until now, identifying the poorly performing queries was challenging and difficult. SQL Server 2016 introduced the Query Store, which automatically tracks query performance. In this course, Solving Real World Problems with SQL Server 2016 Query Store, you'll learn how to solve difficult query performance problems in an easier, more efficient way. This course will show how to identify query performance regressions using the Query Store, how to identify queries using the most resources, and how to track the overall resource consumption at the database level. It'll also show some advanced uses of Query Store, such as upgrade tests and load tests. By the end this course, you’ll be able to use Query Store to identify and resolve what were previously very difficult performance problems.
Register for this course and see more details by visiting:
OpenCourser.com/course/5jqq0l/solving
Here's a deal for you
We found an offer that may be relevant to this course.
Save money when you learn.
All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.
What's inside
Syllabus
Course Overview
Introduction
Solving Query Performance Regressions
Tracking Resource Consumption
Read more
Syllabus
Course Overview
Introduction
Solving Query Performance Regressions
Tracking Resource Consumption
Read more
Configuration and Architecture
Advanced Uses for Query Store
Conclusion
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Suitable for learners who require advanced tools and strategies for addressing query performance problems
Helps identify queries that are consuming the most resources, suitable for performance optimization
Introduces Query Store, a feature that simplifies the process of identifying performance issues in SQL Server 2016
Save this course
Save Solving Real World Problems with SQL Server 2016 Query Store 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 Solving Real World Problems with SQL Server 2016 Query Store with these
activities:
Connect with Experienced SQL Server Performance Engineers on LinkedIn
Show steps
Reaching out to experienced professionals on LinkedIn can provide you with valuable insights and guidance, expanding your knowledge and network in the field of SQL Server performance engineering.
Show steps
-
Identify SQL Server performance engineers on LinkedIn
-
Craft a personalized message requesting mentorship
-
Follow up and maintain communication
Study SQL Server Basics
Show steps
Prepare for course material by reviewing the basics of SQL Server.
Show steps
-
Review online tutorials or documentation on SQL Server basics.
-
Take practice quizzes or exercises to test your understanding.
-
Complete small SQL Server exercises to apply your knowledge.
Review Query Basics
Show steps
Refresh your understanding of query basics to strengthen your foundation for learning SQL Server 2016's Query Store.
Show steps
-
Review a beginner-level SQL tutorial or course
-
Practice writing basic SELECT, INSERT, UPDATE, and DELETE queries
-
Test your understanding by solving simple SQL problems
18 other activities
Expand to see all activities and additional details
Show all 21 activities
Review SQL Server Performance Tuning by Itzik Ben-Gan
Show steps
This book delves into advanced techniques for optimizing SQL Server performance, providing valuable insights to enhance your understanding of query performance issues.
View
T-SQL Querying (Developer Reference)
on Amazon
Show steps
-
Identify sections relevant to the course
-
Read and understand the concepts presented
-
Take notes or highlight key points
Follow Microsoft's Query Store tutorial
Show steps
Strengthen your knowledge by following an official tutorial from Microsoft to gain a comprehensive understanding of Query Store's features and functionality.
Browse courses on
Query Store
Show steps
-
Navigate to the Microsoft Query Store tutorial.
-
Review and understand the concepts and examples provided.
-
Implement the techniques and practices demonstrated in the tutorial.
Walkthrough of SQL Server 2016 Query Store Basics
Show steps
Gain a deeper understanding of SQL Server 2016's Query Store by following a guided tutorial.
Show steps
-
Find a reputable tutorial or course on SQL Server 2016 Query Store
-
Follow the tutorial step-by-step, taking notes and experimenting with the concepts
-
Complete any exercises or quizzes provided in the tutorial
Solve practice problems using Query Store
Show steps
Engage in hands-on practice by solving problems using Query Store to enhance your understanding and improve your skills.
Browse courses on
Query Store
Show steps
-
Access the Query Store table.
-
Filter and identify inefficient queries.
-
Create indexes or rewrite queries to improve performance.
Complete the SQL Server Query Store Tutorial from Microsoft
Show steps
This guided tutorial will provide hands-on experience with the Query Store feature, allowing you to apply these techniques directly in your own environment.
Show steps
-
Access and follow the Microsoft Query Store tutorial
-
Set up the Query Store in your SQL Server instance
-
Run queries and observe the data collected by Query Store
Practice Query Performance Analysis
Show steps
Develop proficiency in analyzing query performance.
Show steps
-
Analyze sample queries to identify inefficiencies.
-
Use Query Store to monitor and track query performance.
-
Implement performance improvements based on analysis.
Identify Performance Bottlenecks with Query Store
Show steps
Develop your ability to identify performance bottlenecks using SQL Server 2016's Query Store.
Show steps
-
Set up a SQL Server database with sample data
-
Run queries on the database and use Query Store to identify performance issues
-
Analyze the Query Store data to pinpoint the root causes of the bottlenecks
-
Apply optimizations to improve query performance
Analyze Query Execution Plans to Identify Performance Bottlenecks
Show steps
By practicing the analysis of query execution plans, you'll develop a deeper understanding of how queries are executed, enabling you to pinpoint performance issues more effectively.
Show steps
-
Obtain a query execution plan for a specific query
-
Interpret the different components of the execution plan
-
Identify potential bottlenecks and performance issues
Configure and Manage Query Store
Show steps
Solidify your understanding of Query Store by configuring and managing it in a real-world scenario.
Show steps
-
Create a new SQL Server database
-
Enable and configure Query Store for the database
-
Monitor the Query Store data and make adjustments as needed
-
Troubleshoot any issues that arise with Query Store
Collaborate on a Query Store project
Show steps
Enhance your learning through collaboration by working with peers on a project involving Query Store, allowing you to share knowledge, learn from others, and deepen your understanding.
Browse courses on
Query Store
Show steps
-
Team up with peers to form a project group.
-
Identify a real-world database performance issue.
-
Apply Query Store to analyze and resolve the issue as a team.
-
Present your findings and solution to the class.
Design a Database Schema with Query Store in Mind
Show steps
Apply Query Store concepts to optimize database design for performance.
Show steps
-
Review principles of database schema design.
-
Consider Query Store's implications for schema decisions.
-
Design a database schema that leverages Query Store for optimal performance.
Write a blog post on Query Store usage
Show steps
Solidify your knowledge by creating a blog post that explains the concepts and benefits of Query Store, helping you organize your thoughts and share your understanding with others.
Browse courses on
Query Store
Show steps
-
Choose an aspect or feature of Query Store to focus on.
-
Research and gather information from credible sources.
-
Organize your content into a logical structure.
-
Write clear and concise explanations.
-
Proofread and edit your post for clarity and accuracy.
Develop a Plan to Implement the Query Store in Your Production Environment
Show steps
Creating a plan for implementing the Query Store in your production environment will solidify your understanding of the practical considerations and challenges involved in real-world deployments.
Show steps
-
Define the goals and objectives for Query Store implementation
-
Identify the necessary resources and infrastructure requirements
-
Develop a timeline and plan for implementation
Discussion on Advanced Query Store Techniques
Show steps
Expand your knowledge by discussing advanced Query Store techniques with peers.
Show steps
-
Join or create a study group or online forum focused on SQL Server Query Store
-
Participate in discussions and share your experiences with Query Store
-
Learn from others and gain new perspectives on advanced Query Store techniques
Participate in SQL Server Performance Tuning Competition
Show steps
Challenge yourself and demonstrate your Query Store knowledge through competition.
Show steps
-
Find or host a SQL Server performance tuning competition.
-
Prepare for the competition by practicing performance analysis and optimization techniques.
-
Participate in the competition and showcase your skills.
Participate in a Peer Mentoring Group for SQL Server Performance Optimization
Show steps
Engaging with other professionals in a peer mentoring group will allow you to share knowledge, discuss challenges, and learn from the experiences of others involved in SQL Server performance optimization.
Show steps
-
Join or create a peer mentoring group focused on SQL Server performance
-
Actively participate in discussions and knowledge sharing
-
Seek and provide feedback on optimization strategies
Contribute to the SQL Server Query Store Community on GitHub
Show steps
Contributing to the open-source community allows you to engage with others working on similar projects, learn from their experiences, and contribute to the advancement of the SQL Server Query Store.
Show steps
-
Identify and select a project or issue related to the Query Store
-
Read the project documentation and codebase
-
Make code contributions or provide feedback on existing issues
Contribute to SQL Server Query Store Open Source Projects
Show steps
Deepen your understanding of Query Store by contributing to its open source community.
Show steps
-
Identify open source projects related to SQL Server Query Store
-
Review the project documentation and identify areas where you can contribute
-
Submit bug reports, feature requests, or code contributions to the project
-
Engage with the project community and learn from others
Connect with Experienced SQL Server Performance Engineers on LinkedIn
Show steps
Reaching out to experienced professionals on LinkedIn can provide you with valuable insights and guidance, expanding your knowledge and network in the field of SQL Server performance engineering.
Show steps
Show steps
Show steps
- Identify SQL Server performance engineers on LinkedIn
- Craft a personalized message requesting mentorship
- Follow up and maintain communication
Study SQL Server Basics
Show steps
Prepare for course material by reviewing the basics of SQL Server.
Show steps
Show steps
Show steps
- Review online tutorials or documentation on SQL Server basics.
- Take practice quizzes or exercises to test your understanding.
- Complete small SQL Server exercises to apply your knowledge.
Review Query Basics
Show steps
Refresh your understanding of query basics to strengthen your foundation for learning SQL Server 2016's Query Store.
Show steps
Show steps
Show steps
- Review a beginner-level SQL tutorial or course
- Practice writing basic SELECT, INSERT, UPDATE, and DELETE queries
- Test your understanding by solving simple SQL problems
18 other activities
Expand to see all activities and additional details
Show all 21 activities
Review SQL Server Performance Tuning by Itzik Ben-Gan
Show steps
This book delves into advanced techniques for optimizing SQL Server performance, providing valuable insights to enhance your understanding of query performance issues.
View
T-SQL Querying (Developer Reference)
on Amazon
Show steps
Show steps
Show steps
- Identify sections relevant to the course
- Read and understand the concepts presented
- Take notes or highlight key points
Follow Microsoft's Query Store tutorial
Show steps
Strengthen your knowledge by following an official tutorial from Microsoft to gain a comprehensive understanding of Query Store's features and functionality.
Browse courses on
Query Store
Show steps
Show steps
Show steps
- Navigate to the Microsoft Query Store tutorial.
- Review and understand the concepts and examples provided.
- Implement the techniques and practices demonstrated in the tutorial.
Walkthrough of SQL Server 2016 Query Store Basics
Show steps
Gain a deeper understanding of SQL Server 2016's Query Store by following a guided tutorial.
Show steps
Show steps
Show steps
- Find a reputable tutorial or course on SQL Server 2016 Query Store
- Follow the tutorial step-by-step, taking notes and experimenting with the concepts
- Complete any exercises or quizzes provided in the tutorial
Solve practice problems using Query Store
Show steps
Engage in hands-on practice by solving problems using Query Store to enhance your understanding and improve your skills.
Browse courses on
Query Store
Show steps
Show steps
Show steps
- Access the Query Store table.
- Filter and identify inefficient queries.
- Create indexes or rewrite queries to improve performance.
Complete the SQL Server Query Store Tutorial from Microsoft
Show steps
This guided tutorial will provide hands-on experience with the Query Store feature, allowing you to apply these techniques directly in your own environment.
Show steps
Show steps
Show steps
- Access and follow the Microsoft Query Store tutorial
- Set up the Query Store in your SQL Server instance
- Run queries and observe the data collected by Query Store
Practice Query Performance Analysis
Show steps
Develop proficiency in analyzing query performance.
Show steps
Show steps
Show steps
- Analyze sample queries to identify inefficiencies.
- Use Query Store to monitor and track query performance.
- Implement performance improvements based on analysis.
Identify Performance Bottlenecks with Query Store
Show steps
Develop your ability to identify performance bottlenecks using SQL Server 2016's Query Store.
Show steps
Show steps
Show steps
- Set up a SQL Server database with sample data
- Run queries on the database and use Query Store to identify performance issues
- Analyze the Query Store data to pinpoint the root causes of the bottlenecks
- Apply optimizations to improve query performance
Analyze Query Execution Plans to Identify Performance Bottlenecks
Show steps
By practicing the analysis of query execution plans, you'll develop a deeper understanding of how queries are executed, enabling you to pinpoint performance issues more effectively.
Show steps
Show steps
Show steps
- Obtain a query execution plan for a specific query
- Interpret the different components of the execution plan
- Identify potential bottlenecks and performance issues
Configure and Manage Query Store
Show steps
Solidify your understanding of Query Store by configuring and managing it in a real-world scenario.
Show steps
Show steps
Show steps
- Create a new SQL Server database
- Enable and configure Query Store for the database
- Monitor the Query Store data and make adjustments as needed
- Troubleshoot any issues that arise with Query Store
Collaborate on a Query Store project
Show steps
Enhance your learning through collaboration by working with peers on a project involving Query Store, allowing you to share knowledge, learn from others, and deepen your understanding.
Browse courses on
Query Store
Show steps
Show steps
Show steps
- Team up with peers to form a project group.
- Identify a real-world database performance issue.
- Apply Query Store to analyze and resolve the issue as a team.
- Present your findings and solution to the class.
Design a Database Schema with Query Store in Mind
Show steps
Apply Query Store concepts to optimize database design for performance.
Show steps
Show steps
Show steps
- Review principles of database schema design.
- Consider Query Store's implications for schema decisions.
- Design a database schema that leverages Query Store for optimal performance.
Write a blog post on Query Store usage
Show steps
Solidify your knowledge by creating a blog post that explains the concepts and benefits of Query Store, helping you organize your thoughts and share your understanding with others.
Browse courses on
Query Store
Show steps
Show steps
Show steps
- Choose an aspect or feature of Query Store to focus on.
- Research and gather information from credible sources.
- Organize your content into a logical structure.
- Write clear and concise explanations.
- Proofread and edit your post for clarity and accuracy.
Develop a Plan to Implement the Query Store in Your Production Environment
Show steps
Creating a plan for implementing the Query Store in your production environment will solidify your understanding of the practical considerations and challenges involved in real-world deployments.
Show steps
Show steps
Show steps
- Define the goals and objectives for Query Store implementation
- Identify the necessary resources and infrastructure requirements
- Develop a timeline and plan for implementation
Discussion on Advanced Query Store Techniques
Show steps
Expand your knowledge by discussing advanced Query Store techniques with peers.
Show steps
Show steps
Show steps
- Join or create a study group or online forum focused on SQL Server Query Store
- Participate in discussions and share your experiences with Query Store
- Learn from others and gain new perspectives on advanced Query Store techniques
Participate in SQL Server Performance Tuning Competition
Show steps
Challenge yourself and demonstrate your Query Store knowledge through competition.
Show steps
Show steps
Show steps
- Find or host a SQL Server performance tuning competition.
- Prepare for the competition by practicing performance analysis and optimization techniques.
- Participate in the competition and showcase your skills.
Participate in a Peer Mentoring Group for SQL Server Performance Optimization
Show steps
Engaging with other professionals in a peer mentoring group will allow you to share knowledge, discuss challenges, and learn from the experiences of others involved in SQL Server performance optimization.
Show steps
Show steps
Show steps
- Join or create a peer mentoring group focused on SQL Server performance
- Actively participate in discussions and knowledge sharing
- Seek and provide feedback on optimization strategies
Contribute to the SQL Server Query Store Community on GitHub
Show steps
Contributing to the open-source community allows you to engage with others working on similar projects, learn from their experiences, and contribute to the advancement of the SQL Server Query Store.
Show steps
Show steps
Show steps
- Identify and select a project or issue related to the Query Store
- Read the project documentation and codebase
- Make code contributions or provide feedback on existing issues
Contribute to SQL Server Query Store Open Source Projects
Show steps
Deepen your understanding of Query Store by contributing to its open source community.
Show steps
Show steps
Show steps
- Identify open source projects related to SQL Server Query Store
- Review the project documentation and identify areas where you can contribute
- Submit bug reports, feature requests, or code contributions to the project
- Engage with the project community and learn from others
Career center
Learners who complete Solving Real World Problems with SQL Server 2016 Query Store will develop knowledge and skills
that may be useful to these careers:
Database Administrator
Database Administrator
Database Administrators are tasked with managing and maintaining databases. They ensure that data is stored securely, efficiently, and in compliance with regulations. Many professionals in this role specialize in a particular relational database management system (RDBMS), such as SQL Server. Thus, a course on SQL Server 2016 Query Store may be useful for professionals in this field. This course teaches skills needed to identify and resolve performance problems in SQL Server, which is a core part of a DBA's responsibilities.
Data Analyst
Data Analyst
Data Analysts collect, clean, and analyze data to help businesses make informed decisions. They often use SQL to query databases and extract insights from data. A course on SQL Server 2016 Query Store may be useful for aspiring and current Data Analysts because it focuses on optimizing query performance. Query performance is essential for data analysts, as they often need to analyze large datasets and produce timely reports.
Data Engineer
Data Engineer
Data Engineers build and maintain the infrastructure that processes and stores data. They often work with large datasets and need to ensure that data is processed and stored efficiently. A course on SQL Server 2016 Query Store may be useful for aspiring and current Data Engineers because it can help them identify and resolve performance problems in SQL Server databases. This is a critical skill for Data Engineers, as they need to ensure that data is processed and stored in a performant manner.
Software Engineer
Software Engineer
Software Engineers design, develop, and maintain software applications. They often work with databases and need to ensure that data is stored and retrieved efficiently. A course on SQL Server 2016 Query Store may be useful for aspiring and current Software Engineers because it can help them identify and resolve performance problems in SQL Server databases. This is a valuable skill for Software Engineers, as they need to ensure that their applications perform well.
Business Intelligence Analyst
Business Intelligence Analyst
Business Intelligence Analysts use data to help businesses make informed decisions. They often use SQL to query databases and extract insights from data. A course on SQL Server 2016 Query Store may be useful for aspiring and current Business Intelligence Analysts because it focuses on optimizing query performance. Query performance is essential for Business Intelligence Analysts, as they often need to analyze large datasets and produce timely reports.
Database Developer
Database Developer
Database Developers design and develop databases. They need to ensure that databases are efficient and meet the needs of the business. A course on SQL Server 2016 Query Store may be useful for aspiring and current Database Developers because it can help them identify and resolve performance problems in SQL Server databases. This is a valuable skill for Database Developers, as they need to ensure that the databases they design and develop perform well.
Data Scientist
Data Scientist
Data Scientists use data to solve business problems. They often use SQL to query databases and extract insights from data. A course on SQL Server 2016 Query Store may be useful for aspiring and current Data Scientists because it focuses on optimizing query performance. Query performance is essential for Data Scientists, as they often need to analyze large datasets and produce timely results.
Systems Analyst
Systems Analyst
Systems Analysts analyze and design business systems. They often work with databases and need to ensure that data is stored and retrieved efficiently. A course on SQL Server 2016 Query Store may be useful for aspiring and current Systems Analysts because it can help them identify and resolve performance problems in SQL Server databases. This is a valuable skill for Systems Analysts, as they need to ensure that the systems they design and implement perform well.
ETL Developer
ETL Developer
ETL Developers design and develop extract, transform, and load (ETL) processes. They need to ensure that ETL processes are efficient and meet the needs of the business. A course on SQL Server 2016 Query Store may be useful for aspiring and current ETL Developers because it can help them identify and resolve performance problems in SQL Server databases. This is a valuable skill for ETL Developers, as they need to ensure that the ETL processes they design and develop perform well.
Database Architect
Database Architect
Database Architects design and develop database architectures. They need to ensure that database architectures are efficient and meet the needs of the business. A course on SQL Server 2016 Query Store may be useful for aspiring and current Database Architects because it can help them identify and resolve performance problems in SQL Server databases. This is a valuable skill for Database Architects, as they need to ensure that the database architectures they design and develop perform well.
Data Warehouse Architect
Data Warehouse Architect
Data Warehouse Architects design and develop data warehouses. They need to ensure that data warehouses are efficient and meet the needs of the business. A course on SQL Server 2016 Query Store may be useful for aspiring and current Data Warehouse Architects because it can help them identify and resolve performance problems in SQL Server databases. This is a valuable skill for Data Warehouse Architects, as they need to ensure that the data warehouses they design and develop perform well.
Performance Analyst
Performance Analyst
Performance Analysts analyze the performance of computer systems. They often work with databases and need to ensure that databases are performing efficiently. A course on SQL Server 2016 Query Store may be useful for aspiring and current Performance Analysts because it can help them identify and resolve performance problems in SQL Server databases. This is a valuable skill for Performance Analysts, as they need to ensure that the computer systems they analyze perform well.
IT Manager
IT Manager
IT Managers plan and direct the activities of an organization's IT department. They need to ensure that the IT department is meeting the needs of the business. A course on SQL Server 2016 Query Store may be useful for aspiring and current IT Managers because it can help them understand the performance of SQL Server databases. This is a valuable skill for IT Managers, as they need to ensure that the IT department is providing the necessary support to the business.
IT Consultant
IT Consultant
IT Consultants provide advice and guidance to organizations on how to use IT effectively. They often work with databases and need to ensure that databases are performing efficiently. A course on SQL Server 2016 Query Store may be useful for aspiring and current IT Consultants because it can help them identify and resolve performance problems in SQL Server databases. This is a valuable skill for IT Consultants, as they need to ensure that the advice they provide is based on sound technical knowledge.
Software Tester
Software Tester
Software Testers test software applications to ensure that they are working correctly. They often work with databases and need to ensure that databases are performing efficiently. A course on SQL Server 2016 Query Store may be useful for aspiring and current Software Testers because it can help them identify and resolve performance problems in SQL Server databases. This is a valuable skill for Software Testers, as they need to ensure that the software applications they test are performing well.
For more career information including salaries, visit:
OpenCourser.com/course/5jqq0l/solving
Reading list
We've selected 12 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
Solving Real World Problems with SQL Server 2016 Query Store.
Save
Provides easy-to-follow recipes for solving common query performance issues in SQL Server 2016.
Provides a more in-depth look at query performance tuning, which is valuable information for learners who want to delve deeper into this topic.
Provides a comprehensive overview of SQL Server execution plans, which is essential knowledge for understanding query performance.
Save
Is written by a leading expert on database performance tuning, offering practical guidance for improving query performance.
Helps build a solid conceptual understanding of SQL performance and optimization techniques.
Provides a solid foundation in the fundamentals of database systems, which is helpful for understanding the underlying concepts of SQL Server and query performance optimization.
Provides a comprehensive overview of data warehousing with SQL Server 2016, including how to use Query Store to improve data warehouse performance. The book is written by a Microsoft Certified Master and provides a practical, hands-on approach to data warehousing.
Save
Provides a comprehensive overview of SQL Server 2016 database administration, including how to use Query Store to manage query performance. The book is written by a Microsoft Certified Master and provides a practical, hands-on approach to database administration.
Provides a technical overview of SQL Server 2016, including how to use Query Store. The book is written by a Microsoft Certified Master and provides a deep dive into the internal workings of SQL Server.
Provides a practical overview of SQL Server query tuning techniques, including how to use Query Store. The book is written by a Microsoft Certified Master and provides a hands-on approach to query tuning.
Provides a comprehensive overview of SQL Server query optimization techniques, including how to use Query Store to improve query performance. The book is written by a database expert and provides a deep dive into the theory and practice of query optimization.
Provides a comprehensive overview of database systems concepts and applications, including how to use Query Store to improve database performance. The book is written by database experts and provides a deep dive into the theory and practice of database systems.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/5jqq0l/solving
Share
Similar courses
Here are nine courses similar to
Solving Real World Problems with SQL Server 2016 Query Store.
Effective Query Analysis with SQL Server Tools
OpenCourser.com/course/2g9ivm/effective
Effective Query Analysis with SQL Server Tools
Most relevant
Identifying & Fixing Performance Issues Caused by Parameter Sniffing
OpenCourser.com/course/6w343k/identifying
Identifying & Fixing Performance Issues Caused by...
Most relevant
Analyzing SQL Server Query Plans
OpenCourser.com/course/25k2jm/analyzing
Analyzing SQL Server Query Plans
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 2017: Diagnosing Configuration Issues with DMVs
OpenCourser.com/course/b5j474/sql
SQL Server 2017: Diagnosing Configuration Issues with DMVs
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
Real-world Scenarios: SQL Server Query Tuning in Action
OpenCourser.com/course/1w9vm7/real
Real-world Scenarios: SQL Server Query Tuning in Action
Most relevant
Azure SQL Database: Diagnosing Performance Issues with DMVs
OpenCourser.com/course/qdy137/azure
Azure SQL Database: Diagnosing Performance Issues with...
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
Time
121 hours
Level
Intermediate
Via
Pluralsight
Instructor
Gail Shaw
Language
English
Good to know
Suitable for learners who require advanced tools and strategies for addressing query performance problems
Helps identify queries that are consuming the most resources, suitable for performance optimization
Introduces Query Store, a feature that simplifies the process of identifying performance issues in SQL Server 2016
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