fbpxl
Global - (+34) 91 414 89 50 | N. America - (800) 757 6543 contact@solidq.com

Private Onsite | 5 Days Classroom

SQL Server Performance Tuning and Troubleshooting
(Versions 2017, 2016 and 2014)

Learn the internal architecture of SQL Server and the typical environments it operates in.

Diagnose problems and optimize the performance of your SQL Server environment. SQL Server 2017 already incuded!

Main Benefits

Configure database physical storage and filegroups.

j

Detect and optimize common poorly performing coding practices.

Troubleshoot and optimize locking and concurrency issues.

/

Manage database compression.

Mantain database for optimal performance.

R

Troubleshoot common virtualization problems.

Optimize data loading.

Optimize and mantain statistics.

i

Read, unterstand and toubleshoot complex execution plans.

Upcoming Dates

 Sep 23, 2019 – Vienna Enroll here 

Course Delivery Options

Private Onsite.

The course will take place in your companie’s facilities. We limit attendance to no more than 20 students in order to maintain a good level of interactivity.

5 Days Classroom.

The course will take place in a classroom with no more than 20 students in order to maintain a good level of interactivity.

Pre-requisites

We recommend to have experience with SQL Server (SQL Server administration and Transact-SQL programming) and knowledge of database and SQL Server Performance Tuning concepts.
After this Course
Along the course you will learn the basis of the architecture of SQL Server, focussing on the key subsystems, and the key problem areas.
Join us and you’ll be able to optimize the overall performance of your Data Server and also to anticipate potetial problems and mitigate their effects!

Very knowledgeable and good energy. Kept the class moving and engaged.

Developer

Instructors

Itzik Ben – Gan

Itzik Ben-Gan is a Mentor and Co-Founder of SolidQ. A Data Platform Microsoft MVP (Most Valuable Professional) since 1999, Itzik has delivered numerous training events around the world focused on T-SQL Querying, Query Tuning and Programming. Itzik is the author of several books including T-SQL Fundamentals Third Edition and T-SQL Querying. He has written articles for SQL Server Pro, SolidQ Journal, MSDN and SQL Performance blog. Itzik’s speaking activities include SQLPASS, SQLBits, SQL Nexus, SQLU, SQLTeach and various user groups around the world. Itzik is the author of SolidQ’s Advanced T-SQL Querying, Programming and Tuning and T-SQL Fundamentals courses along with being a primary resource within the company for their T-SQL related activities.

Herbert Albert

Herbert Albert is a Mentor and Managing Director of SolidQ’s Central and Eastern Europe subsidiary. Since SQL Server 6.0 Albert worked as a consultant, a database developer and trainer and holds several Microsoft certifications including MCT. He was involved in the development of several Microsoft Official Curriculum courses. Herbert co-authored “SQL Server Upgrade Technical Reference Guide” for SQL Server 2008 and 2012 and the Microsoft Press book “SQL Server 2005 Step-by-Step Applied Techniques”. He is a regular speaker at international conferences and events. As a trainer Herbert is focused on courses for T-SQL programming and performance tuning, which he delivers successfully all over Europe.

Course Outline

Module 1. SQL Architecture
  • SQL Server Components
  • Network Layer
  • The Database Engine
  • SQL OS
  • Virtualized vs. Physical
  • Module 2. SQL Server Performance Monitoring Tools
  • Anatomy of a Monitoring Solution
  • Dynamic Management Objects (DMV/DMF)
  • Extended Events and Tracing
  • System and Performance Monitor
  • Creating and Analyzing a Baseline
  • Query Store in SQL 2016
  • Third Party Tools
  • Module 3. CPU and Scheduling
  • Scheduling Architecture and Configurations
  • Scheduling
  • NUMA
  • Parallelism
  • Waits and Queues
  • Troubleshooting and Tuning
  • Resource Governor
  • Module 4. SQL Server Memory
  • Memory Architecture in SQL Server
  • Memory Configuration
  • Buffer Pool Extension
  • Memory Monitoring
  • Module 5. SQL Server IO
  • Storage Internals
  • Transaction Log and Recovery
  • Bulk Operations
  • Delayed Durability
  • Pre-Installation Testing
  • Best Practices
  • Troubleshooting tempdb
  • Monitoring IO
  • Data Compression
  • Module 6. Query Optimization and
  • Cardinality Estimation
  • Working with Statistics
  • Query Optimization
  • Query Execution
  • Plan Caching and Recompilation
  • Module 7.SQL Server Indexes and Query Plan Analysis
  • Execution Plan Basics
  • Indexes
  • Clustered and Non-Clustered Indexes
  • Filtered Indexes
  • Indexed Views
  • Indexes on Computed Columns
  • Index Analysis
  • Searchable Arguments
  • Monitoring Index Usage
  • Workload Optimization
  • Index Fragmentation
  • Rebuild vs Reorg
  • Analyzing Execution Plans
  • Physical Operators
  • Joins
  • Spills and Warnings
  • Module 8. SQL Server Concurrency
  • Locking, Latching and Spinlocks
  • Deadlocks and Blocking
  • Monitoring Concurrency
  • Transaction Isolation Levels
  • Snapshot Isolation and Row Versioning
  • Locking Hints
  • Module 9. SQL Server In-Memory Technologies
  • In-Memory Overview
  • ColumnStore Indexes
  • In-Memory OLTP (Hekaton)
  • Contact us

    Do you want more info about these courses?

    • By submitting this information, you acknowledge that you have read the Privacy Policy and that you consent to our data processing in accordance with this Statement.