SQL Server 2016 ile Performans Tuning Eğitimi

Module 1: SQL Query Performance Tuning Path

The Performance-Tuning Process
The Performance Baseline
Where to Focus Efforts in Tuning
The Top 10 SQL Server Performance Killers

Module 2: SQL Query Performance Analysis

Performance Monitor Tool
Retrieve Performance Monitor Data by DMV
The Basics of the SQL Server Profiler Tool
How to Analyze Costly Queries by SQL Server Profiler Tool
How to Track Query Performance by DMV
How to Measure the Cost of SQL Query Using SQL Utilities

Module 3: SQL Server Storage Fundamentals

How SQL Server Store Data
Intorduction to Extent and Extent Types
What is Page?
Anatomy of a Data Page
Page Types Details
Advanced DBCC Command for Extent and Pages

Module 4: Index Analysis

What an Index Is
The Benefits and Overhead of an Index
General Recommendation for Index Design
Clustered and Non-Clustered Index Behavior and Comparison
Advanced Indexing Techniques
Manage Very Large Indexes
Special Index Types

Module 5: Execution Plan Details

Introduction to Execution Plan Generation and Caching
Execution Plan General Operators
Execution Plan Join Operators
Execution Plan Spool and Paralelizm Operators
Controlling Execution Plan With Query and Table Hints
Parameter Sniffing Scenarios
SQL Server 2016 Query Store

Module 6: Statistics Analysis

The role of Statistics in Query Optimization
The importance of Statistics on Columns with Indexes
The Computation of Selectivity of a Column for Indexing
Statistics Maintenance

Module 7: Fragmentation Analysis

The causes of Index Fragmentation, Including an Analysis of Page Splits
The overhead costs associated with fragmentation
The Computation of Selectivity of a Column for Indexing
How to analyze the amount of fragmentation
Techniques used to resolve fragmentation
The significance of the FILLFACTOR in helping to control fragmentation

Module 8: Query Design Analysis

Aspects of Query design that affect performance
How query design use indexes effectively
The role of optimizer hints on query performance
The role of database constraints on query performance
Techniques to reduce the Transaction cost of a query

Module 9: Transaction Log and Tempdb Optimization

How Transaction Log Used by SQL Server
How to configure the transaction log
What is Tempdb
Benefits of Tempdb database to optimize queries
How to configure the Tempdb database

Module 10: SQL Server Advanced Features

In Memory OLTP Details
Delayed Durability
Buffer Pool Extension
ColumnStore Technology Details

Module 11: Blocking Analysis

The fundamentals of blocking in SQL Server
Database Locks Granularity, Escalation, Modes and Compatibility
ANSI Isolation Levels
Resolutions and Recommendations to Avoid Blocking
Deadlock Fundamentals
Error Handling to Catch a Deadlock
Techniques to Resolve a Deadlock

Module 12: SQL Server Optimization Checklist

Database Design Checklist
How to configure the transaction log
Query Design Checklist
Configuration Setting Checklist
Database Administration Checklist
Database Backup Checklist

KAYIT OL

Detaylar

Tarih:

Gün:

Saat:

Süre: 18 Saat

Fiyat: 1800 TL

Eğitmen:

BİLGİLENDİRME

Eğitim fiyatlarına KDV dahil değildir.

Eğitimler en az 6 kişi ile açılır. Yeterli katılımcı sayısına ulaşılamayan durumlarda eğitim bir defaya mahsus ertelenir.

Kurumsal kapalı grup eğitim teklifleriniz için bizimle iletişime geçebilirsiniz.

EĞİTİM DOKÜMANI

EĞİTİMİN AMACI

SQL Server Performance Tuning eğitimi ile birlikte sisteminizde çalışan sorguların performanslarını izleyip test edebilecek ve gerekli gördüğünüz sorgularınız için Execution Plan'ları inceleyeip sorgunuzun en hızlı şekilde çalışabilecek yapıya gelmesini sağlayabileceksiniz. Eğitim sonrasında SQL Server indeks mimarisi ile beraber, Execution Plan operatörleri, istatistik objeleri ile perfomansı doğrudan etkileyen faktörlere hakim olup, veritabanı performansınızı arttırabilecek doğru hamleleri hızlıca yapabileceksiniz.