PLU | Managing SQL Server Database Performance (2019 EN)

Company: Pluralsight
Author: Viktor Suha
Full Title: Managing SQL Server Database Performance
Year: 2019
Language: English
Genre: Educational: Databases
Skill Level: Intermediate
Price: -
-
Files: MP4 (+ Subtitles .SRT, Slides .PDF)
Time: 02:51:00
Video: AVC, 1280 x 720 (1.778) at 30.000 fps, 200 kbps
Audio: AAC at 96 Kbps, 2 channels, 48.0 KHz



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.

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.


Lessons:
1. Course Overview
01. Course Overview
2. Aiming for Performance and Scalability
02. Introduction
03. A Holistic and Layered Approach
04. Definitions and Methods
05. Aiming for Scalability and Performance
06. Scope and Assets
07. Overview
3. Understanding Key SQL Server Concepts
08. Major Versions and Compatibility Levels
09. Patch Levels and Servicing
10. Editions and Best Practices
11. Server Instances
12. Server Configuration Options
13. Database Configuration Options
14. Trace Flags
15. Tempdb
16. Transaction Log and Recovery Models
17. Memory Management and SQLOS
18. Wait Statistics and the Threading Model
4. Optimizing SQL Server Instance and Memory Configuration
19. Server Health Check
20. Demo: Memory Settings
21. Demo: Parallelism Settings
22. Demo: ERRORLOG Files
5. Optimizing Tempdb and User Database File Configuration
23. Database File IO
24. Instant File Initialization and Tempdb Bottlenecks
25. Demo: Autogrowth Settings
26. Demo: Tempdb Configuration
6. Configuring SQL Server in Azure
27. SQL Server in Azure
28. SQL Server Virtual Machines
29. Demo: Creating SQL Server Virtual Machines and Sizing
30. Azure SQL Database
31. Elastic Pools
32. Demo: Estimating Service Tiers and Sizes
7. Troubleshooting and Baselining the Environment
33. Troubleshooting and Baselining in SQL Server
34. Wait Statistics in Practice
35. IO and CPU Related Wait Type Patterns
36. OS, Locking, and Data Page Related Wait Type Patterns
37. Wait Statistics Patterns in Troubleshooting
38. Demo: Wait Statistics Analysis with Custom Query
39. IO Performance Troubleshooting with DMVs
40. Demo: IO Performance Analysis with Custom Query
41. Query Store
42. Demo: Using the Query Store for Query Performance Analysis
43. System_health Session Trace
44. Demo: Using the System_health Session Trace for Troubleshooting
45. Perfmon Traces
46. Interesting SQL Server Counters
47. Page Life Expectancy Patterns
48. Demo: Using and Analyzing Perfmon Traces
49. Module and Course Summary

Our members see more. Join us!
-------------
Our members see more. Join us!