Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Provider Logo

Troubleshooting SQL Server Performance Problems

via Pluralsight

Overview

This course presents two customer scenarios to demonstrate hands-on approaches to troubleshoot and resolve SQL Server performance problems in Production database environments.

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.

Topics:
  • Course Overview
  • Troubleshooting Methodology Overview
  • Troubleshooting Performance Problems with SQL Server on Azure VM
  • Troubleshooting Performance Problems with Azure SQL Database

Taught by

Viktor Suha

Related Courses

Reviews

0.0 rating, based on 0 reviews

Start your review of Troubleshooting SQL Server Performance Problems

Never stop learning Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free