Save for later

Troubleshooting SQL Server Performance Problems

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.

Get Details and Enroll Now

OpenCourser is an affiliate partner of Pluralsight.

Get a Reminder

Not ready to enroll yet? We'll send you an email reminder for this course

Send to:

Pluralsight

Rating Not enough ratings
Length 1.8 hours
Starts On Demand (Start anytime)
Cost $35/month (Access to entire library- free trial available)
From Pluralsight
Instructors v, i, K, t, o, r
Download Videos On Windows, MacOS, iOS, and Android Pluralsight app
Language English
Subjects IT & Networking
Tags Data Professional

Get a Reminder

Get an email reminder about this course

Send to:

Similar Courses

Careers

An overview of related careers and their average salaries in the US. Bars indicate income percentile.

SQL Server Administrator $77k

IT Conslutant - SQL Server $83k

SQL Server/Oracle DBA $95k

SQL Server Instructor $95k

PHP and SQL Server Developer $103k

SQL Server | BI SQL Server developer $108k

Microsoft SQL Server Developer $109k

Database Administrator SQL Server $115k

SQL Server DBA 5 $122k

SQL Server Architect $138k

SQL Server MVP 5 $156k

SQL Server MVP 3 $163k

Write a review

Your opinion matters. Tell us what you think.

Pluralsight

Rating Not enough ratings
Length 1.8 hours
Starts On Demand (Start anytime)
Cost $35/month (Access to entire library- free trial available)
From Pluralsight
Instructors v, i, K, t, o, r
Download Videos On Windows, MacOS, iOS, and Android Pluralsight app
Language English
Subjects IT & Networking
Tags Data Professional

Similar Courses

Sorted by relevance

Like this course?

Here's what to do next:

  • Save this course for later
  • Get more details from the course provider
  • Enroll in this course
Enroll Now