Use 75% Discount Code: HAPPY75
(Now: US$ 258 . After Discount: US$ 64.5)

(GST + Internet Transaction Fee additional)

SQL Server Performance Tuning and Troubleshooting

Speakers: Denis Reznik

8-hrs Virtual Classroom Training Recordings

Subscription Period: Lifetime Access

Abstract:

Nothing is perfect, which means that your database maybe not perfect as well. And one day you may decide that your database is slow and it’s time to optimize it. But.. Where to start? When to end? What to look at? Which queries are slow? How to identify the real bottleneck? And so on, and so on. There are a lot of questions that should be answered in a process of performance tuning.

In this workshop, we will find answers to all these questions going from collecting data for analysis, through identifying bottlenecks to optimization of the particular queries. In this way, we will learn performance tuning practical techniques and solve a bunch of issues in real time. And despite I’m a big fan of Profiler and old-fashioned tools and technics, new, more interesting and useful instruments are available nowadays, so will use them to find the bottleneck and tune performance. Minimum of theory and a lot of practice.

Modules

1. SQL Server Internals

• SQL Server Architecture
• SQL Server Network Interface
• Query Processing
• Query plan and query plan cache
• Query Optimizer
• Indexes and Statistics
• Physical Joins
• Parallel Query Plan
• Storage Engine
• Transaction Log and Database Recovery Model
• Locks
• Transaction isolation levels
• Deadlocks
• SQLOS
• System resources
• SQLOS and system resources usage
• Query execution and resources consumption
• Typical wait types

2. Searching for Performance Issue Root Cause

• Finding Global Performance Issues with Performance Monitor
• Finding Queries that cause performance Issues with Common Tools
• Extended Events
• Dynamic Management Views
• Query Store

3. Optimizing Query

• Query Execution Time
• Optimization Algorithm
• First-Level Root Cause(s)
• Second-Level Root Cause(s)
• Query Optimization and Query Plan Analysis

8-hrs Virtual Classroom Training Recordings