Performance Tuning Training Classes
 
 

Performance Tuning (Query Tuning)

This impeccable Query Tuning course is exclusively designed for SQL Developers, MSBI Developers and Database Consultants. Course includes Mid Level to Advanced Query Tuning Techniques including Memory Optimized Tables, Temporal Objects, LIVE Query Stats, Partitions, Stats, DTA, Index Plans, Execution Plans, DDM, SQL Buffer Space, In-Memory, Lookup Options, Query Store, Dynamic Objects, DOP, Query Priority Settings, more...!


Schedules for SQL Server Performance (Query) Tuning

Timings (IST) Schedule Register
   
6:30 AM to 8 AM May 15th Register
10 AM to 11:30 AM May 22nd Register
7 PM to 8:30 PM June 5th Register

 

None of the above schedules work for you? Register @ 24 x 7 Video Training

If you are aware of SQL Server T-SQL then Register for SQL DBA Training
Trainer: Mr Sai Phanindra T (11+ Yrs Exp)
 
Dur: 6 Days (1 Hr per day)

Course Fee: INR 3000

 
HIGHLIGHTS
✔ Daily Tasks ✔ Real-time
✔ LIVE Execution Plans ✔ 3rd Party Tools
✔ 70-461 Certification ✔ 70-462 Certification
 
Level 1 Tuning Options
Level 2 Tuning Options

Chapter 1: QUERY TUNING - CTE, JOIN OPTIONS, STATS

  • LIVE Query Statistics and Table Statistics
  • Sub Queries Versus Joins. Use of CTEs & Memory
  • Using CTEs for Memory Based Query Pre-Fetch
  • Avoiding Self Joins, Options. Real-world Scenarios
  • Query Tuning and Resource Optimization Options
  • HASH JOIN - Examples and Precautions
  • MERGE JOIN - Examples and Precautions
  • LOOP JOIN - Examples and Precautions
  • JOIN Options - Performance Comparison
  • Real-world Scenarios @ ERP (LIVE) Database

Chapter 5: MEMORY TABLES, LIVE EXECUTION PLANS

  • Memory Optimized Tables, Temporal Data Access
  • In-Memory Tables Creation and Index Options
  • Memory Tables Versus Temp Tables/Table Variables
  • LIVE Execution Statistics, Hash Plans, Performance
  • Natively Compiled Stored Procedures, Performance
  • Creating System Versioned Temporal Tables
  • Querying and Modifications to Temporal Tables
  • Bulk Inserts, OPENROWSET with Temporal Tables
  • Tuning Bulk Inserts - Resource Allocations
  • Real-world Scenarios @ ERP (LIVE) Database

Chapter 2: INDEXED QUERIES, STATISTICS, MISSING INDEXES

  • Index Internals and Execution Plans
  • Index Fragmentation - Issues, Performance
  • SAMPLED and DETAILED Query Scans. FillFactor
  • Index Rebuilds, Query Tuning Options
  • Index Reorganization Process and Advantages
  • Page, Row Compressions with Indexes - Cautions
  • Filtered Indexes, Online Indexes, Indexes Views
  • GAM, SGAM Pages, Metadata Header Info
  • Filtered Indexes and Size Limitations
  • Analyzing Work Load Tables and Scans
  • Table Statistics & Query Tuning Options
  • Statistics Role in Query Tuning Process

Chapter 6: DATABASE TUNING ADVISOR (DTA) TOOL, DOP

  • DTA: Usage, Sequential / Parallel Query Tuning
  • DTA Tool with Profiler, Trace Tables, Cache
  • Understanding Workload Files & Tables in Profiler
  • SQL Profiler Tuning and Tuning Templates
  • Database Tuning Advisor (DTA) - Usage
  • Understanding PDS Options with Indexes
  • Choosing Correct Option (PDS) for Tuning
  • Resource Governor - Resource Pools - Tuning
  • Classifier Functions, Cost Based Optimization
  • Query Priority, CPU / Memory / IO Limits
  • Windows Fibres, Priority Boost, DOP Options
  • Real-world Scenarios @ ERP (LIVE) Database

Chapter 3: PARTITIONS and DATA COMPRESSIONS

  • Big Data - Performance Considerations
  • Table Partitions & Query Tuning Options
  • Partition Functions and Partition Schemes
  • Partition Ranges, Values and Sort Orders
  • Partitioned Data, Long Running Queries
  • Partitioning Un-partitioned Structures
  • Aligned Partitioning and Performance
  • Fill Factor, Pad Index and Query Tuning
  • Statistics with Table & Index Partitions
  • Statistics for Query Conditions, Audits
  • Data Compression Types and Query Tuning
  • ROW & PAGE Compressions. Differences
  • Performance Issues - Data Compressions
  • Partition Numbers, Filtered Compressions
  • Managing Partitions and Tuning Options

Chapter 7: MEMORY & RESOURCES - PERFORMANCE IMPACT

  • System Monitor Tool & Long Running Queries
  • Activity Monitor Tool For CPU & Disk IO
  • PERFMON Counters and PSSDIAG Tools
  • Tempdb Space Issues and Performance Impact
  • Log Space Issues and Performance Impact
  • Memory Pages & IO Resources : Query Performance
  • MEMORY LEAKS & PAGE WAITS: Query Performance
  • LATCH WAITS and Query Performance Impact
  • Tuning Data Loads : OLTP to Stage, DWH, OLAP
  • Long Running Queries and Dynamic Views : RCA
  • Query Handle and Plan Handle Audits, IO Options
  • Understanding Query Statistics - Tuning Options
  • New Query Tuning Features in SQL Server 2016
  • Database Reports and Server Dashboards
  • One Real-time Project Implementation

Chapter 4: FULL TEXT INDEXES (FTS)

  • LIKE Operator - Limitations & Wild-cards
  • Full Text Search (FTS) Configuration
  • Full Text Search Service and Importance
  • Filter Daemon Launcher Server - Options
  • Database Catalogs (FTC) and Storage
  • Full Text (FT) Indexes for Query Tuning
  • Full Text Columns and Primary Index
  • Full Text Index and Searching Queries
  • Full Population, Incremental Population
  • CONTAINS() and FREETEXT() Functions
  • Token Search, Inflectional Forms Search
  • Manual Data Populations, Index Loads
  • Backups, Restores with FT Catalog Files
  • CHANGE_TRACKING Options, Limitations
  • Securing FT Catalogs and FT Indexes
  • Performance Tuning with FT Indexes

Chapter 8: SQL Server 2016/2017 - New Tuning Options

  • Temporal Tables & SYSTEM_VERSIONING
  • PERFMON Counters and PSSDIAG Tools
  • Secured Column Access - DDM Functions
  • Index Management Options - SQL 2016
  • Distributed Replay Controller Tool, SCOM
  • Data Migration Assistant (DMA) Tool
  • Using DMA Tool for DB Analysis, Upgrades
  • Server and Database Analysis, SSIS
  • PSSDIAG Tool - Performance Monitoring
  • SQL Browser Server - TCP IP, Trace Flags
  • CPU, Thread Management and Windows Fibres
  • Priority Boost Settings and Windows Kernel
  • Working with Machine Code @ SQL Server 2016
  • Non-TSQL queries in SSMS - Performance Benefits!!
  • Index Management Options - SQL Server 2016
  • Performance Tuning - Checklist Activities

Register Today

 

All Classes are Instructor-Led & LIVE. Completely Practical and Real-time with Study Material, Session Notes, Tasks and 24x7 LIVE Server.

 

Trainer : Mr. Sai Phanindra T, 11+ Yrs of Experience exclusively on SQL Server, SQL DBA, more..

Training Reviews

Register Now

 

Register Today:

 

 

Job-Oriented Real-time Training @ SQL School Training Institute


 

Register Today

 

 

Register Today

 

SQL School Phone IndiaIndia: +91 (0)9666440801
SQL School Phone USAUSA: +1(510) 400-4845
 

WHY CHOOSE US:

Microsoft Partner (ID# 4338151)

100% Real-Time and Practical

ISO 9001:2008 Certified

24/7 LIVE Server Access

Real Time Projects

Theory Material in Advance

Weekly Mock Interviews

Placement Assistance

Job Support

OFFICE 1:

#108/2RT, Road #1, Beside SR Nagar Bus Stop, Ameerpet, Hyd-38

India: 0091 (0)9666440801

Map
OFFICE 2:

Sai Anu Avenue, Street #3,
Patrika Nagar, HITEC City, Hyd - 81

India: 0091 (0)9666440801

Map

OUR RATINGS

Google: 4.7/5

Facebook: 4.8/5

Sulekha: 4.8/5

JustDial: 4.7/5

MouthShut: 5/5

UrbanPro: 5/5

Yet5: 5/5

 
 

©2008-2017 SQL School, Regd®: Sequelgate (I) Technologies Pvt. Ltd™

Sql School is an Authorized Microsoft Training Partner (ID# 4338151)

SequelGate (I) Technologies Pvt.Ltd. is rated 4.8/5 by www.facebook.com/Sqlschool based on 107 reviews

FOLLOW US:
social
social
social
social
social
social