SQL Server 2016 ile Performans Tuning

Awesome Image


Her Yönüyle SQL Server 2019 ile Performans Tuning

  • Module 1: Module 1: SQL Query Performance Tuning Path

    +The Performance-Tuning Processi

    +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