We may earn an affiliate commission when you visit our partners.
Course image
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
PRE REQUISTES TO SQL SERVER PERFORMANCE TUNING PART 2
DOWNLOADING THE APPLICATIONS
CREATING VM AND INSTALLING WINDOWS 2016 OS
INSTALLING SQL 2017
INSTALLING SQL 2017 PART 2
SQL SERVER VERSION COMPARISON
PERFMOM
PERFORMANCE COUNTERS
SAVING PERMON COUNTERS
DATA COLLECTION SET
DATA COLLECTION SET PART 2
ADDING ADVENTUREWORKS 2017
ANALYSIS OF METRICS
BASELINE CPU
SQL PROFILER
LIMIT PROFILER DATA
PERFMON AND PROFILER
EXTENDED EVENTS PART 1
EXTENDED EVENTS PART 2
EXTENDED EVENTS SESSION SCRIPT
FIND LONGEST RUNNING QUERY
DMVS
SETTING UP QUERY STORE
QUERY STORE
QUERY STORE PART 2
FORCED PLAN
FORCED PLAN PART 2
INDEXING AND FRAGMETATION
SQL AGENT JOB FOR INDEX AND OLA
SQL AGENT JOB FOR INDEX AND OLA PART 2
DTA INDEXING AND QUERY STORE
SOLVING RECOMPILATION
SOLVING COMPILATION PART 2
RESOVLING PAGE SPLITS PART 1
RESOVLING PAGE SPLITS PART 2
VIEWING PAGE SPLITS VIA EXTENDED EVENTS
RESOLVING BLOCKING ISSUES
TEMPDB PERFORMANCE
TEMPDB PERFORMANCE PART 2
DATABASE BACKUPS
WAIT STATS

Good to know

Know what's good
, what to watch for
, 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

Save SQL Server Performance Tuning Part 2 to your list so you can find it easily later:
Save

Reviews summary

Quick and concise sql server tuning course

Learners say this SQL Server Performance Tuning Part 2 is quick and concise. While the reviews are largely positive, some students say that the course moves too quickly.
Learners found this course to be concise and easy to follow.
"Good course, but i feel like it was too quick not a lot of deep dive"
Some learners complained that the course moves a bit too quickly.
"Good course, but i feel like it was too quick not a lot of deep dive"

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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.

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.
Provides a detailed explanation of SQL Server execution plans, and how to use them to troubleshoot performance problems.
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.
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.
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.
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.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Here are nine courses similar to SQL Server Performance Tuning Part 2.
Real-world Scenarios: SQL Server Query Tuning in Action
Most relevant
SQL Server Performance Tuning Part 1
Most relevant
Advanced Query Optimization Techniques in SQL Server
Most relevant
Monitoring, Troubleshooting, and Optimizing SharePoint...
Most relevant
Analyzing SQL Server Query Plans
Most relevant
What Every Developer Should Know About SQL Server...
Most relevant
SQL Server 2017: Diagnosing Performance Issues with DMVs
Most relevant
SQL Server: Scaling SQL Server 2012 and 2014: Part 2
Most relevant
Effective Query Analysis with SQL Server Tools
Most relevant
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