SQL Server 2014 ile Performans Tuning

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: 18.11.2016

Gün: Cumartesi-Pazar

Saat: 10:00 - 16:00

Süre: 18 Saat

Fiyat: 1250 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.

KAYIT OL

Katılımcı Yorumları

Siz de Yorum Yapın

Katılımcı Görüşleri

Yukarı Çık