Managing SQL Server Database Performance

SQL Server performance problems are real and troubleshooting can be a challenge. This course will cover what factors affect performance and how to troubleshoot and optimize performance both on-premise and with Azure SQL Database.
Course info
Rating
(10)
Level
Intermediate
Updated
Jul 30, 2019
Duration
2h 51m
Table of contents
Course Overview
Aiming for Performance and Scalability
Understanding Key SQL Server Concepts
Optimizing SQL Server Instance and Memory Configuration
Optimizing Tempdb and User Database File Configuration
Configuring SQL Server in Azure
Troubleshooting and Baselining the Environment
Description
Course info
Rating
(10)
Level
Intermediate
Updated
Jul 30, 2019
Duration
2h 51m
Description

SQL Server performance troubleshooting and optimization are often overwhelming, complex, and take a very long time in production environments. However, this should not be the case. By understanding the exact problem with proper communication and having the best methods and tools to address the problems, the efforts and resources invested into the entire process could be cut significantly or could even be fully prevented. In this course, Managing SQL Server Database Performance, you’ll gain a better understanding and address some of the key factors that can contribute to or impact database performance adversely, beyond the workload you run. First, you’ll explore how to approach performance and scalability issues in general and what methods are preferred for efficiency. Next, you’ll discover a few important SQL Server concepts to help you understand how things work under the hood, along with optimization techniques for server memory and tempdb configuration. Finally, you’ll learn what factors like sizing and choosing the proper service tier, you need to watch out for in Microsoft Azure. When you’re finished with this course, you’ll have the skills and knowledge to prevent major problems, troubleshoot, and optimize your SQL Server environment more efficiently to better manage your SQL Server database workloads.

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

Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone. My name is Viktor Suha, and welcome to my course, Managing SQL Server Database Performance. I am currently a database developer and DBA at GSGroup. Have you experienced performance problems with your SQL Server database solution and had a challenge to identify the root causes and resolve them? In this course, we are going to explore what external factors can adversely impact the database performance, even if your workload is seemingly optimized. Also, we are going to cover the troubleshooting and optimization methods to either prevent or resolve these problems. Some of the major topics that we will cover include the importance of server maintenance, including patching SQL Server; optimizing SQL Server memory settings and tempdb configuration; estimating Azure SQL Database service tiers and sizes; troubleshooting common performance problems with wait statistics. By the end of this course, you'll know how to prevent common SQL Server performance problems from happening in the first place and how to troubleshoot performance problems more efficiently. Before beginning the course, you should be familiar with using SQL Server Management Studio to be able to run queries against any version of SQL Server. From here, you should feel comfortable further diving into performance troubleshooting and optimization with courses on SQL Server Wait Statistics, Automatic Tuning in Azure SQL Database, and Using the SQL Server Query Store. I hope you will join me on this journey to learn about performance troubleshooting and optimization with the Managing SQL Server Database Performance course, at Pluralsight.