OpenCourser brand icon
Sign in
We may earn an affiliate commission when you visit our partners.
Pluralsight logo

Analyzing SQL Server Query Plans

Pinal Dave

Every database server runs different workloads and queries. You will learn how to analyze query plans and troubleshoot SQL Server performance problems.

Read more

Every database server runs different workloads and queries. You will learn how to analyze query plans and troubleshoot SQL Server performance problems.

Every database server runs different workloads and queries, and it's important for a SQL Server Performance Tuning Expert to identify queries that are negatively impacting performance. In this course, Analyzing SQL Server Query Plans, you will gain the ability to identify performance bottlenecks on your database. First, you will learn to analyze query plans. Next, you will discover and understand query execution plans. Finally, you will explore how to resolve the performance bottleneck. When you are finished with this course, you will have the skills and knowledge of analyzing the query plans needed to troubleshoot SQL Server performance problems.

Enroll now

What's inside

Syllabus

Course Overview
Capture Query Plans Using Extended Events and Traces
Identify Poorly Performing Query Plan Operators
Create Efficient Query Plans Using Query Store
Read more
Compare Estimated and Actual Query Plans and Related Metadata
Configure Azure SQL Database Performance Insight
Summary

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Core audience: SQL database administrators and developers
Develops SQL Server performance tuning skills
Taught by Pinal Dave, a recognized SQL Server expert
Covers industry-standard tools and techniques
Includes hands-on labs and exercises
Requires prior knowledge of SQL Server

Save this course

Save Analyzing SQL Server Query Plans to your list so you can find it easily later:
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 Analyzing SQL Server Query Plans with these activities:
Organize Your Course Materials
Prepare for a successful learning experience by organizing your course materials and building a strong foundation.
Show steps
  • Review the course syllabus and make a list of key concepts and topics.
  • Gather your lecture notes, assignments, and any other relevant materials.
  • Create a dedicated folder or notebook for your course materials.
Review Database Fundamentals
Warm-up your SQL knowledge by reviewing the core concepts of database management systems.
Browse courses on Database Fundamentals
Show steps
  • Revisit topics such as database design, data modeling, and query optimization.
  • Enroll in an online refresher course or watch video tutorials covering these topics.
Analyze Query Plans with Real-World Data
Solidify your understanding of query plans by analyzing real-world queries.
Browse courses on Performance Troubleshooting
Show steps
  • Set up a SQL Server instance with sample data.
  • Capture and analyze query plans for different queries.
  • Identify performance bottlenecks and optimize queries accordingly.
Five other activities
Expand to see all activities and additional details
Show all eight activities
Join a SQL Server Performance Tuning Study Group
Connect with other learners and share your experiences and knowledge related to SQL Server performance tuning.
Show steps
  • Join an online or local study group focused on SQL Server performance tuning.
  • Participate in discussions, ask questions, and share your insights.
Explore Query Store for Performance Insights
Dive into Query Store and leverage its features to gain actionable insights into SQL Server performance.
Browse courses on Query Store
Show steps
  • Enable and configure Query Store on your SQL Server instance.
  • Use Query Store to identify slow queries and optimize them.
  • Monitor query performance over time and identify trends.
Share Your Performance Tuning Insights
Expand your understanding by sharing your knowledge and insights on SQL Server performance tuning.
Browse courses on SQL Server Performance
Show steps
  • Write a blog post or article on a specific performance tuning technique.
  • Create a presentation or video tutorial to demonstrate your knowledge.
  • Participate in online forums and discussions related to SQL Server performance.
Build a Performance Tuning Plan
Take your SQL Server performance tuning skills to the next level by developing a comprehensive performance tuning plan.
Browse courses on Performance Tuning
Show steps
  • Gather performance data and analyze query plans.
  • Identify performance bottlenecks and develop optimization strategies.
  • Implement optimization techniques and monitor the results.
  • Document your findings and create a detailed performance tuning plan.
Build a Database Performance Monitoring Dashboard
Gain hands-on experience by building a dashboard to track and visualize SQL Server performance metrics.
Browse courses on Performance Monitoring
Show steps
  • Gather requirements and design the dashboard layout.
  • Develop the dashboard using tools like Power BI or Tableau.
  • Integrate real-time data sources to display performance metrics.
  • Configure alerts and notifications for critical performance indicators.

Career center

Learners who complete Analyzing SQL Server Query Plans will develop knowledge and skills that may be useful to these careers:
SQL Server Performance Tuning Expert
SQL Server Performance Tuning Experts are responsible for identifying and resolving performance bottlenecks in SQL Server databases. They work with database administrators and developers to ensure that databases are running at optimal performance. The Analyzing SQL Server Query Plans course provides SQL Server Performance Tuning Experts with the skills and knowledge needed to identify and resolve performance bottlenecks in SQL Server databases. This course can help SQL Server Performance Tuning Experts improve their job performance and advance their careers.
See salaries and explore the career path for SQL Server Performance Tuning Expert
Database Server Administrator
Database Server Administrators are responsible for installing, configuring, maintaining, and monitoring database management systems. They also provide support to users, ensuring that databases are available and running smoothly. The Analyzing SQL Server Query Plans course provides Database Server Administrators with the skills and knowledge needed to identify and resolve performance bottlenecks in SQL Server databases. This course can help Database Server Administrators improve their job performance and advance their careers.
See salaries and explore the career path for Database Server Administrator
Data Analyst
Data Analysts are responsible for collecting, cleaning, and analyzing data to identify trends and patterns. They use this information to help businesses make better decisions. The Analyzing SQL Server Query Plans course can help Data Analysts improve their skills in querying and analyzing data. This course can help Data Analysts become more effective in their roles and advance their careers.
See salaries and explore the career path for Data Analyst
Data Engineer
Data Engineers are responsible for designing, building, and maintaining data pipelines. They also work with data scientists and other analysts to develop data-driven solutions. The Analyzing SQL Server Query Plans course can help Data Engineers improve their skills in working with SQL Server databases. This course can help Data Engineers become more effective in their roles and advance their careers.
See salaries and explore the career path for Data Engineer
Database Developer
Database Developers are responsible for designing, developing, and maintaining databases. They work with database administrators to ensure that databases are reliable, scalable, and secure. The Analyzing SQL Server Query Plans course can help Database Developers improve their skills in working with SQL Server databases. This course can help Database Developers become more effective in their roles and advance their careers.
See salaries and explore the career path for Database Developer
Web Developer
Web Developers are responsible for designing, developing, and maintaining websites. They work with other developers to create websites that are user-friendly and meet the needs of the business. The Analyzing SQL Server Query Plans course may be helpful for Web Developers who work with SQL Server databases. This course can help Web Developers understand how to query and analyze data in SQL Server databases.
See salaries and explore the career path for Web Developer
Data Scientist
Data Scientists are responsible for collecting, cleaning, and analyzing data to identify trends and patterns. They use this information to help businesses make better decisions. The Analyzing SQL Server Query Plans course may be helpful for Data Scientists who work with SQL Server databases. This course can help Data Scientists understand how to query and analyze data in SQL Server databases.
See salaries and explore the career path for Data Scientist
Technical Support Engineer
Technical Support Engineers are responsible for providing technical support to users. They help users resolve problems with hardware, software, and networks. The Analyzing SQL Server Query Plans course may be helpful for Technical Support Engineers who work with SQL Server databases. This course can help Technical Support Engineers understand how to query and analyze data in SQL Server databases.
See salaries and explore the career path for Technical Support Engineer
Software Developer
Software Developers are responsible for designing, developing, and maintaining software applications. They work with other engineers to create software that meets the needs of users. The Analyzing SQL Server Query Plans course may be helpful for Software Developers who work with SQL Server databases. This course can help Software Developers understand how to query and analyze data in SQL Server databases.
See salaries and explore the career path for Software Developer
Systems Analyst
Systems Analysts are responsible for analyzing business processes and designing solutions to improve efficiency. They work with other stakeholders to gather requirements and develop solutions that meet the needs of the business. The Analyzing SQL Server Query Plans course may be helpful for Systems Analysts who work with SQL Server databases. This course can help Systems Analysts understand how to query and analyze data in SQL Server databases.
See salaries and explore the career path for Systems Analyst
Network Administrator
Network Administrators are responsible for designing, implementing, and maintaining computer networks. They also provide support to users, ensuring that networks are available and running smoothly. The Analyzing SQL Server Query Plans course may be helpful for Network Administrators who work with SQL Server databases. This course can help Network Administrators understand how to query and analyze data in SQL Server databases.
See salaries and explore the career path for Network Administrator
Business Analyst
Business Analysts are responsible for analyzing business processes and identifying opportunities for improvement. They work with other stakeholders to gather requirements and develop solutions that meet the needs of the business. The Analyzing SQL Server Query Plans course may be helpful for Business Analysts who work with SQL Server databases. This course can help Business Analysts understand how to query and analyze data in SQL Server databases.
See salaries and explore the career path for Business Analyst
Software Engineer
Software Engineers are responsible for designing, developing, and maintaining software applications. They work with other engineers to create software that meets the needs of users. The Analyzing SQL Server Query Plans course may be helpful for Software Engineers who work with SQL Server databases. This course can help Software Engineers understand how to query and analyze data in SQL Server databases.
See salaries and explore the career path for Software Engineer
Database Administrator
Database Administrators are responsible for installing, configuring, maintaining, and monitoring database management systems. They also provide support to users, ensuring that databases are available and running smoothly. The Analyzing SQL Server Query Plans course may be helpful for Database Administrators who work with SQL Server databases. This course can help Database Administrators understand how to query and analyze data in SQL Server databases.
See salaries and explore the career path for Database Administrator
IT Consultant
IT Consultants are responsible for providing advice and guidance to businesses on how to use technology to improve their operations. They work with businesses to identify and resolve technology problems. The Analyzing SQL Server Query Plans course may be helpful for IT Consultants who work with SQL Server databases. This course can help IT Consultants understand how to query and analyze data in SQL Server databases.
See salaries and explore the career path for IT Consultant

Reading list

We've selected ten 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 Analyzing SQL Server Query Plans.
Cover image
Query Store for SQL Server 2019
Save
Provides a detailed overview of SQL Server execution plans, explaining how they work and how to use them to identify and resolve performance issues. It also includes a number of real-world examples to illustrate the concepts discussed.
Query Store for SQL Server 2019: Identify and Fix...
Paperback
$$
Query Store for SQL Server 2019: Identify and Fix...
Kindle Edition
$$
Cover image
SQL Performance Explained
Save
Provides a comprehensive explanation of SQL performance, covering topics such as query optimization, index design, and database architecture. It also includes a number of tips and tricks for improving the performance of SQL queries.
SQL Performance Explained Everything Developers...
Paperback
$$
Cover image
SQL Server MVP Deep Dives, Volume 2
Save
Provides a practical guide to optimizing the performance of SQL Server databases, covering topics such as query tuning, index design, and hardware optimization. It also includes a number of case studies to illustrate the concepts discussed.
SQL Server MVP Deep Dives, Volume 2
Kindle Edition
$$
Cover image
T-SQL Querying
Save
Provides advanced techniques for tuning SQL Server queries, covering topics such as query plan analysis, index design, and database configuration. It also includes a number of real-world examples to illustrate the concepts discussed.
T-SQL Querying (Developer Reference)
Paperback
$$$
T-SQL Querying (Developer Reference)
Kindle Edition
$$
Cover image
Microsoft SQL Server 2008 Internals
Save
Provides a comprehensive overview of the SQL Server engine, covering topics such as memory management, query processing, and transaction management. It valuable resource for anyone who wants to understand how SQL Server works.
Microsoft SQL Server 2008 Internals (Pro -...
Unknown Binding
$$$$
Cover image
T-SQL Window Functions
Save
Provides a detailed explanation of the SQL Server query optimizer, covering topics such as query plan generation, cost estimation, and query optimization techniques. It valuable resource for anyone who wants to understand how SQL Server optimizes queries.
T-SQL Window Functions
Paperback
Check
T-SQL Window Functions
Kindle Edition
Check
Cover image
Pro SQL Server Internals
Save
Provides a comprehensive overview of the SQL Server internals, covering topics such as memory management, query processing, and transaction management. It valuable resource for anyone who wants to understand how SQL Server works.
Pro SQL Server Internals
Paperback
$$
Pro SQL Server Internals
Kindle Edition
$$
Cover image
Deciphering Data Architectures
Save
Provides a practical guide to analyzing the performance of SQL Server queries, covering topics such as query plan analysis, index design, and query optimization techniques. It valuable resource for anyone who wants to improve the performance of their SQL Server queries.
Deciphering Data Architectures: Choosing Between a...
Paperback
$$$
Deciphering Data Architectures
Kindle Edition
$$
Cover image
Pro SQL Server 2008 Mirroring
Save
Provides a comprehensive guide to SQL Server performance tuning, covering topics such as query tuning, index design, and database configuration. It valuable resource for anyone who wants to improve the performance of their SQL Server databases.
Pro SQL Server 2008 Mirroring (Expert's Voice in...
Paperback
$$$
Cover image
SQL Server 2022 Query Performance Tuning
Save
Provides a comprehensive guide to SQL Server performance tuning, covering topics such as query tuning, index design, and database configuration. It valuable resource for anyone who wants to improve the performance of their SQL Server databases.
SQL Server 2022 Query Performance Tuning
Paperback
Check
SQL Server 2022 Query Performance Tuning
Kindle Edition
Check

Share

Help others find this course page by sharing it with your friends and followers:
Facebook
LinkedIn
Reddit
X
Link
Email

Similar courses

Here are nine courses similar to Analyzing SQL Server Query Plans.
Effective Query Analysis with SQL Server Tools
Most relevant
Real-world Scenarios: SQL Server Query Tuning in Action
Most relevant
Advanced Query Optimization Techniques in SQL Server
Most relevant
Solving Real World Problems with SQL Server 2016 Query...
Most relevant
Querying Data Using T-SQL
Most relevant
Troubleshooting SQL Server Performance with sp_WhoIsActive
Most relevant
SQL Server Data Manipulation Essentials
Most relevant
Managing SQL Server Database Performance
Most relevant
Troubleshooting and Optimizing SSRS Reporting
Most relevant
Course image
Time
150 hours
Level
Advanced
Via
Pluralsight
Instructor
Pinal Dave
Language
English
This course belongs to a collection called Developing SQL Server Databases. It's comprised of ten courses:
  1. Designing and Implementing SQL Server Tables and Views
  2. Designing and Implementing SQL Server Database Indexes
  3. Programming SQL Server Database Stored Procedures
  4. Programming SQL Server Database Triggers and Functions
  5. Managing SQL Server Database Concurrency
  6. Using Memory-optimized Tables and Native Stored Procedures
  7. Optimizing SQL Server Statistics and Indexes
  8. Analyzing SQL Server Query Plans (viewing)
  9. Managing SQL Server Database Performance
  10. Managing Azure SQL Server Database Performance
Good to know
Core audience: SQL database administrators and developers
Develops SQL Server performance tuning skills
Taught by Pinal Dave, a recognized SQL Server expert
Covers industry-standard tools and techniques
Includes hands-on labs and exercises
Requires prior knowledge of SQL Server
Share and help others discover this course.
Facebook LinkedIn X Reddit Link Email
Don't miss out
Enroll today to gain access to this course
Enroll in this course
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