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

SQL Server Performance Tuning Part 2

4.6 Filled star Filled star Filled star Filled star Half star
Based on 2,548 ratings
see reviews
Raphael Asghar

This course is designed for any student who has knowledge ofSQL Administration and wants to learn about SQL Server performance tuning theirSQL servers. You must have the prerequisiteSQL performance tuning part 1 course.

Read more

This course is designed for any student who has knowledge ofSQL Administration and wants to learn about SQL Server performance tuning theirSQL servers. You must have the prerequisiteSQL performance tuning part 1 course.

This is the second part of SQL Server performance tuningcourse; at the end of this course the student will be able to resolve and troubleshootissues related index tuning, page splitting, tempb database sizing,recompilation of stored procedures, and much more with the use of tools andutilities such the performance monitor This will allow you tohave an optimum running SQL Server and an extensive knowledge of how to troubleshoot and resolve the more pressing issues you may face in your environment.

Enroll now

What's inside

Learning objective

This is the second part of sql server performance tuning course; at the end of this course the student will be able to resolve and troubleshoot issues related index tuning, page splitting, tempb database sizing, recompilation of stored procedures, and much more with the use of tools and utilities such the performance monitor, dta, dmvs, extended events, profiler and other tools.

Syllabus

This is the second part of SQL Server performance tuning course; at the end of this course the student will be able to resolve and troubleshoot issues related index tuning, page splitting, tempb
Read more

Traffic lights

Read about what's good
what should give you pause
and possible dealbreakers
Covers tools and techniques regarded as standard in the software industry
Features instructors, Raphael Asghar, who are recognized for their work in the field of SQL Server performance tuning
Explores topics that are highly relevant to software development in both industry and academia

Save this course

Create your own learning path. Save this course to your list so you can find it easily later.
Save

Reviews summary

Advanced sql server performance tuning

According to learners, this course provides a solid foundation and practical knowledge for SQL Server performance tuning, building effectively on prerequisite material (Part 1). Many find the instructor knowledgeable and appreciate the practical demos covering key tools like Extended Events, Query Store, and DMVs. Students report gaining immediately applicable skills for troubleshooting issues like index tuning, page splits, and TempDB performance. While some older reviews mention minor audio/video quality issues or feeling the pace is fast, the consensus among recent reviews highlights the clarity and comprehensive coverage of advanced topics, making it a valuable resource for professionals.
Opinions vary on pacing and topic depth.
"Okay course. Covers the topics listed, but sometimes feels a bit rushed."
"Felt like it just scratched the surface on some topics. Expected more depth."
Effectively continues material from the first course part.
"Excellent course building on Part 1."
"Assumes you are already quite comfortable with SQL Server Admin, even beyond Part 1."
Instructor demonstrates strong expertise in the subject.
"The instructor clearly knows their stuff and provides useful demos. Highly recommend..."
"Good coverage of performance tuning tools. ... The instructor is knowledgeable."
"The instructor is clearly an expert and shares valuable real-world insights."
Excellent coverage of key performance tuning tools and areas.
"The sections on Extended Events and Query Store were particularly valuable."
"I found the TempDB and Indexing modules very helpful."
"Solid content covering key tuning areas. ... Good resource."
Provides skills directly applicable to work environments.
"Learned a lot about DTA and DMVs that I can use immediately at work. Well worth the time."
"Absolutely brilliant! The most comprehensive guide to tuning I've found online. The wait stats section alone was worth the price."
"This course provides practical tools and strategies that I could apply immediately to my work."
Some reviewers note audio/video issues.
"Some of the audio quality was a bit patchy in earlier lectures, but the core info is sound."
"Disappointing. The video quality was poor in places and the explanations weren't always clear."

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 SQL Server Performance Tuning Part 2 with these activities:
Join a study group or online community focused on SQL Server performance tuning
Participating in a study group or online community will provide you with opportunities to discuss performance tuning issues, share knowledge, and collaborate on solutions.
Show steps
  • Identify and join a relevant study group or online community
  • Regularly participate in discussions, ask questions, and share your experiences
Create a library of resources on SQL Server performance tuning best practices
Compiling a library of resources on best practices will provide you with a valuable repository of knowledge and guidance for optimizing SQL Server performance.
Browse courses on Performance Optimization
Show steps
  • Gather reputable resources from books, articles, whitepapers, and online forums
  • Organize and categorize the resources based on specific performance tuning topics
  • Create a central repository, such as a shared drive or online platform, for easy access to the library
Volunteer to assist with performance tuning projects in open-source communities or non-profit organizations
Volunteering your skills in performance tuning projects will provide you with practical experience, contribute to the community, and enhance your understanding of real-world performance challenges.
Browse courses on SQL Server
Show steps
  • Identify open-source projects or non-profit organizations that require assistance with performance tuning
  • Contact the project maintainers or organizers and offer your services
  • Collaborate with the team to identify and resolve performance issues
Five other activities
Expand to see all activities and additional details
Show all eight activities
Attend a workshop on advanced SQL Server performance tuning techniques
Attending a workshop on advanced performance tuning techniques will provide you with practical knowledge and hands-on experience in resolving complex performance issues in SQL Server.
Show steps
  • Research and identify reputable workshops that cover advanced SQL Server performance tuning techniques
  • Enroll in the workshop and actively participate in the sessions
  • Apply the learned techniques to your own SQL Server environment to improve performance
Customize Performance Monitor counters for monitoring specific metrics
Customizing Performance Monitor counters will equip you with valuable skills for monitoring specific performance metrics related to SQL Server, enabling you to proactively identify and address potential issues.
Browse courses on Performance Monitoring
Show steps
  • Identify the key performance metrics that need to be monitored for your environment
  • Use Performance Monitor to create custom counters based on the identified metrics
  • Configure thresholds and alerts to be notified when the metrics exceed specified values
  • Monitor the custom counters regularly and analyze the data to identify trends and potential performance issues
Implement a script to resolve blocking issues
Writing a script to resolve blocking issues will enhance your understanding of the causes and solutions for performance bottlenecks related to blocking.
Browse courses on Performance Tuning
Show steps
  • Identify the blocking queries using tools like DMVs or Extended Events
  • Analyze the query execution plans to determine the source of the blocking
  • Implement appropriate solutions to resolve blocking issues, such as indexing, query optimization, or lock contention management
  • Test the script in a controlled environment to verify its effectiveness
Develop a performance tuning plan for a specific SQL Server instance
Creating a performance tuning plan will provide you with a structured approach to identify, diagnose, and resolve performance issues in your SQL Server instance, leading to improved performance and efficiency.
Show steps
  • Gather and analyze baseline performance data using tools like Performance Monitor or SQL Server Profiler
  • Identify performance bottlenecks and potential areas for improvement
  • Develop and implement a comprehensive plan to address the identified performance issues
  • Monitor the performance improvements and make adjustments to the plan as needed
Participate in a SQL Server performance tuning competition or hackathon
Participating in a competition or hackathon will challenge you to apply your performance tuning skills in a competitive environment, fostering innovation and pushing the boundaries of your knowledge.
Browse courses on Performance Optimization
Show steps
  • Identify and register for a relevant competition or hackathon
  • Form a team or work individually to develop and implement performance tuning solutions
  • Present your findings and compete for recognition or prizes

Career center

Learners who complete SQL Server Performance Tuning Part 2 will develop knowledge and skills that may be useful to these careers:
Data Analyst
Data Analysts need expertise in SQL queries to explore and prepare data for analysis, a core topic of this SQL Server Performance Tuning Part 2 course. You will learn about index tuning, which is crucial for optimizing data retrieval and improving query performance. Furthermore, this course covers troubleshooting and resolving issues related to page splitting, which can significantly impact data access speed. This course will provide you with the skills and knowledge to excel as a Data Analyst.
See salaries and explore the career path for Data Analyst
Database Administrator
Database Administrators are responsible for maintaining and optimizing database systems, including SQL Server. This SQL Server Performance Tuning Part 2 course will help you develop the skills to diagnose and resolve performance issues, ensuring optimal database performance. You will gain expertise in using tools like Performance Monitor, Profiler, and Extended Events to identify bottlenecks and implement effective solutions. This course is highly recommended for professionals aspiring to excel in Database Administration.
See salaries and explore the career path for Database Administrator
Business Intelligence Analyst
Business Intelligence Analysts utilize SQL queries to extract meaningful insights from data. By taking this SQL Server Performance Tuning Part 2 course, you will gain a deep understanding of index tuning, page splitting, and other techniques to optimize SQL queries. This will enable you to efficiently gather and analyze data, providing valuable insights to drive informed decision-making within organizations.
See salaries and explore the career path for Business Intelligence Analyst
Software Engineer
Software Engineers are often involved in designing and developing database systems. This SQL Server Performance Tuning Part 2 course will equip you with the knowledge to optimize SQL queries and troubleshoot performance issues. You will learn about indexing strategies, query optimization techniques, and the use of performance monitoring tools. This course will enhance your ability to build efficient and scalable software applications that effectively manage data.
See salaries and explore the career path for Software Engineer
Data Architect
Data Architects design and manage data systems, including SQL Server databases. This SQL Server Performance Tuning Part 2 course will provide you with the skills to optimize database performance, ensuring the efficient retrieval and processing of data. You will learn about index tuning, query optimization, and the use of performance monitoring tools. This course will help you build a solid foundation for a successful career as a Data Architect.
See salaries and explore the career path for Data Architect
Database Developer
Database Developers are responsible for designing, developing, and maintaining database systems. This SQL Server Performance Tuning Part 2 course will enhance your skills in optimizing SQL queries and troubleshooting performance issues. You will gain expertise in index tuning, query optimization techniques, and the use of performance monitoring tools. This course will empower you to build and manage efficient and scalable database systems.
See salaries and explore the career path for Database Developer
Systems Analyst
Systems Analysts analyze and design computer systems, including database systems. This SQL Server Performance Tuning Part 2 course will provide you with the knowledge to evaluate and improve the performance of SQL Server databases. You will learn about index tuning, query optimization, and the use of performance monitoring tools. This course will enhance your ability to design and implement efficient and effective computer systems.
See salaries and explore the career path for Systems Analyst
IT Manager
IT Managers oversee the planning, implementation, and management of IT systems, including database systems. This SQL Server Performance Tuning Part 2 course will provide you with the knowledge to make informed decisions about database performance optimization. You will learn about index tuning, query optimization, and the use of performance monitoring tools. This course will help you lead your team in implementing efficient and reliable database systems.
See salaries and explore the career path for IT Manager
Performance Engineer
Performance Engineers are responsible for optimizing the performance of computer systems, including database systems. This SQL Server Performance Tuning Part 2 course will provide you with the skills to identify and resolve performance bottlenecks in SQL Server databases. You will learn about index tuning, query optimization, and the use of performance monitoring tools. This course will help you develop the expertise to ensure the optimal performance of complex systems.
See salaries and explore the career path for Performance Engineer
Data Scientist
Data Scientists use data to extract insights and solve problems. This SQL Server Performance Tuning Part 2 course may be helpful for you, as it covers techniques for optimizing the performance of SQL queries. By understanding how to efficiently retrieve and process data, you can improve your ability to analyze large datasets and extract valuable insights.
See salaries and explore the career path for Data Scientist
Software Architect
Software Architects design and develop software systems, including database systems. This SQL Server Performance Tuning Part 2 course may be helpful for you, as it covers techniques for optimizing the performance of SQL queries. By understanding how to efficiently retrieve and process data, you can design and implement software systems that are efficient and scalable.
See salaries and explore the career path for Software Architect
Cloud Architect
Cloud Architects design and implement cloud computing solutions, including database systems. This SQL Server Performance Tuning Part 2 course may be helpful for you, as it covers techniques for optimizing the performance of SQL queries in a cloud environment. By understanding how to efficiently retrieve and process data, you can design and implement cloud-based solutions that are efficient and scalable.
See salaries and explore the career path for Cloud Architect
DevOps Engineer
DevOps Engineers are responsible for the development and operation of software systems, including database systems. This SQL Server Performance Tuning Part 2 course may be helpful for you, as it covers techniques for optimizing the performance of SQL queries. By understanding how to efficiently retrieve and process data, you can contribute to the development and operation of efficient and reliable software systems.
See salaries and explore the career path for DevOps Engineer
Network Engineer
Network Engineers design, implement, and maintain computer networks, including database systems. This SQL Server Performance Tuning Part 2 course may be helpful for you, as it covers techniques for optimizing the performance of SQL queries over a network. By understanding how to efficiently retrieve and process data, you can design and implement networks that are efficient and reliable.
See salaries and explore the career path for Network Engineer
Security Analyst
Security Analysts are responsible for protecting computer systems and networks from security threats, including database systems. This SQL Server Performance Tuning Part 2 course may be helpful for you, as it covers techniques for optimizing the performance of SQL queries in a secure manner. By understanding how to efficiently retrieve and process data, you can contribute to the development of secure and reliable systems.
See salaries and explore the career path for Security Analyst

Reading list

We've selected seven 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 SQL Server Performance Tuning Part 2.
Cover image
Query Store for SQL Server 2019
Save
Provides a detailed explanation of SQL Server execution plans, and how to use them to troubleshoot performance problems.
Query Store for SQL Server 2019: Identify and Fix...
Paperback
$$
Query Store for SQL Server 2019: Identify and Fix...
Kindle Edition
$$
Cover image
PostgreSQL 16 Administration Cookbook
Save
Provides a comprehensive overview of PostgreSQL performance tuning. It covers a wide range of topics, such as index tuning, query optimization, and hardware optimization, and it includes a number of case studies and examples to help you apply the techniques you learn.
PostgreSQL 16 Administration Cookbook: Solve real...
Kindle Edition
$$
Cover image
High Performance MySQL
Save
Provides a comprehensive overview of MySQL performance tuning. It covers a wide range of topics, such as index tuning, query optimization, and hardware optimization, and it includes a number of case studies and examples to help you apply the techniques you learn.
High Performance MySQL: Optimization, Backups, and...
Paperback
$$
High Performance MySQL: Optimization, Backups,...
Paperback
$$
(中文) High Performance MySQL ( 3rd Edition ) (MySQL...
Paperback
$$
Cover image
Professional SQL Server 2012 Internals and...
Save
Provides a practical guide to troubleshooting SQL Server performance issues.
Professional SQL Server 2012 Internals and...
Paperback
Check
Professional SQL Server 2012 Internals and...
Kindle Edition
Check
Cover image
Pro SQL Server 2022 Wait Statistics
Save
Provides a deep dive into SQL Server performance tuning, with a focus on advanced techniques.
Pro SQL Server 2022 Wait Statistics: A Practical...
Paperback
$$
Pro SQL Server 2022 Wait Statistics: A Practical...
Kindle Edition
$$
Cover image
SQL Tuning
Save
Provides a comprehensive overview of SQL tuning. It covers a wide range of topics, such as index tuning, query optimization, and hardware optimization, and it includes a number of case studies and examples to help you apply the techniques you learn.
SQL Tuning: Generating Optimal Execution Plans
Paperback
$$
SQL Tuning: Generating Optimal Execution Plans
Kindle Edition
$$
Cover image
MCTS Self-Paced Training Kit (Exam 70-667)
Save
Provides a comprehensive overview of advanced SQL tuning. It covers a wide range of topics, such as index tuning, query optimization, and hardware optimization, and it includes a number of case studies and examples to help you apply the techniques you learn.
MCTS Self-Paced Training Kit (Exam 70-667):...
Paperback
$$

Share

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

Similar courses

Similar courses are unavailable at this time. Please try again later.

Udemy Buyer Protection & Guarantee

Verified partner policies & purchase protections

Global Marketplace Leader
Free Trial & Audit

Free Lecture Previews

Free preview video lectures available for all courses; optional 7-day free trial on Personal Plan subscriptions (cancel before trial ends to avoid conversion).

Return & Refund Policy

30-Day Money-Back Guarantee

30-day money-back guarantee on all eligible individual course purchases (provided course content has not been substantially consumed or downloaded). Subscription fees are non-refundable once billed.

Buyer Protections

Verified Academic & Industry Partner

Lifetime access to purchased individual courses and future updates, verifiable certificate of completion, and direct student Q&A forums.

Key Purchase Protections
30-day 100% money-back guarantee on course purchases
Lifetime access on web, mobile, and offline
Certificate of completion included with purchase
Direct instructor Q&A and active student community
OpenCourser Verified Partner Policy details last reviewed: 2026-10-22
Course image
Rating
4.6 Filled star Filled star Filled star Filled star Half star
Effort
7.5 total hours
Via
Udemy
Instructor
Raphael Asghar
Language
English
Traffic lights
Read about what's good
what should give you pause
and possible dealbreakers
Covers tools and techniques regarded as standard in the software industry
Features instructors, Raphael Asghar, who are recognized for their work in the field of SQL Server performance tuning
Explores topics that are highly relevant to software development in both industry and academia
Share this
Share to help others discover this course.
Facebook LinkedIn X Reddit Link Email
Begin learning today
Enroll now to gain full access to SQL Server Performance Tuning Part 2.
Enroll now
Save for later
Add this course to your list. Find it anytime.
Save
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 - 2025 OpenCourser