SQL Server Performance Tuning (Query Tuning) at SQL School

[sequelschool]

SQL Server Performance Tuning (Query Tuning) at SQL School

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	June 26th	Register
③	7 PM to 8:30 PM	July 25th	Register

 

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

Trainer: Mr Sai Phanindra T (11+ Yrs Exp)

 

Duration: 6 Days (1 Hr per day) 

Course Fee: INR 4000
 

 

HIGHLIGHTS

✔ Daily Tasks	✔ Real-time
✔ LIVE Execution Plans	✔ 3rd Party Tools
✔ 70-461 Certification	✔ 70-462 Certification

 

 

SQL Server Performance Tuning (Query Tuning)

Register Today

 

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 @ http://sqlschool.com/SQL-Performance-Tuning.html