Troubleshooting SQL Server Performance Problems

This course presents two customer scenarios to demonstrate hands-on approaches to troubleshoot and resolve SQL Server performance problems in Production database environments.
Course info
Level
Beginner
Updated
Jul 2, 2020
Duration
1h 46m
Table of contents
Course Overview
Troubleshooting Methodology Overview
Troubleshooting Performance Problems with SQL Server on Azure VM
Troubleshooting Performance Problems with Azure SQL Database
Description
Course info
Level
Beginner
Updated
Jul 2, 2020
Duration
1h 46m
Description

SQL Server performance troubleshooting often implies advanced techniques and methods. There is a vast array of tools, scripts and utilities to help you troubleshoot different problems. Problem complexity is virtually endless though, meanwhile the database environment is changing constantly with the focus slowly moving away from on-premises environments to cloud deployments. There are no two customer scenarios that are exactly the same. The key to successful troubleshooting is to understand the exact nature of the problem then build up the troubleshooting process with a structure as well as have at least a basic understanding of how the underlying technology works. In this course, Troubleshooting SQL Server Performance Problems, you’ll gain a better understanding to approach troubleshooting as a process, by having a conversation with your customer and asking relevant questions. In order to provide you a more hands-on experience, you will follow the resolution of different performance problems in two real-life customer scenarios. First, you’ll explore a performance problem with a report dashboard in a SQL Server on Azure VM environment. Next, you’ll discover performance optimization techniques with another report dashboard in an Azure SQL Database environment. When you’re finished with this course, you’ll have the skills to approach SQL Server performance troubleshooting with a methodology and to apply SQL Server specific troubleshooting techniques.

About the author
About the author

Viktor is a SQL Server database developer and DBA having major experience with large enterprise environments and customers. He mainly worked in the financial industry and also at Microsoft in the Premier Support organization for 10 years

More from the author
Managing SQL Server Database Maintenance
Beginner
1h 43m
Dec 30, 2019
Managing SQL Server Database Performance
Intermediate
2h 50m
Jul 30, 2019
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone. My name is Victor Suha, and welcome to my course, troubleshooting SQL Server Performance Problems. I'm a SQL Server database developer and DBA. How would you troubleshoot your customers' database performance problem based on minimal information? How would you explore the problem behavior from the application perspective? How would you address multiple problems overlapping each other? Memory configuration, reporting infrastructure, as well T‑SQL coding issues? In this course, we are going to explore how to approach SQL Server performance troubleshooting as a process, ask relevant questions, and apply SQL Server troubleshooting methods to find the root cause in two real‑life customers scenarios. Some of the major topics that we will cover include troubleshooting methodology, Azure VM sizing, memory configuration, query blocking problems, scalar UDF inlining. By the end of this course, you'll know how to approach troubleshooting with a structure and apply SQL Server performance troubleshooting techniques. Before beginning the course, you should be familiar with using SQL Server Management Studio and writing basic T‑SQL queries. From here, you should feel comfortable diving into SQL Server performance troubleshooting and optimization with courses on SQL Server Indexing for Performance, Query Plan Analysis. Automatic Tuning in Azure SQL Database. I hope you'll join me on this journey to learn performance troubleshooting with the Troubleshooting SQL Server Performance Problems course, at Pluralsight.