Tuesday, September 18, 2018

SQL Performance Internals Training

SQL Server 2014 Performance Internals Training Schedule


 Start Date

 End Date

 Class Days

 Class Time

 Class Type




 May 9, 2015

 Jun 28, 2015

 Sat & Sun.

 7 - 8:30 pm EST

 Live Instructor-Led

 $849 (USD)



Want to become a SQL Server master?

Learn the internals of performance tuning troubleshooting using SQL Server 2014. This course covers everything you need to know to optimize queries, troubleshooting locks and blocks, detecting and troubleshooting CPU, IO and Memory related issues.

This is an advanced course delivered to both individuals and corporate teams with basic knowledge of SQL Server. This course focuses on real-life scenarios and helps you become an advanced SQL Server Professional.


Who Should Attend this Class?

This course is designed for advanced SQL Server developers, DBA's and users that already have working knowledge of SQL Server and are interested in learning the internals of SQL Server 2014 performance tuning.  It covers topics that helps you gain solid insight in to SQL Server 2014 Performance Internals.



This course is open to anyone with knowledge of SQL Server. You also need to have basic knowledge of Microsoft Windows operating system and its core functionality.


*Special pricing available for companies with 10+ employees


SQL Server Performance Internals Topics Included: (Click here to view the syllabus)

  • Internals of Indexes – Clustered and non-clustered index
  • Database Files – data file, log file, good practices
  • Understanding Lock Resources
  • Lock Modes and Compatibility
  • Lock Hierarchy
  • Isolation Levels
  • Identifying Blocking using DMV’s and Activity Monitor
  • Lock WAIT Types
  • Common causes of Blocking
  • Locking hints and Lock Timeout
  • What are deadlocks?
  • How to detect deadlocks
  • How to troubleshoot deadlocks
  • Detecting and Diagnosing Spinlock Contention
  • Best Practices to prevent Locks, blocks and deadlocks
  • Common causes of high CPU
  • Detecting queries causing high CPU’s
  • Performance Counters to use for Identifying CPU Bottleneck
  • Detecting inefficient query plans
  • Troubleshooting Excessive Query Compilation and Optimization
  • Detecting and Troubleshooting Intra-query Parallelism
  • Identifying and Troubleshooting Unnecessary Recompilation
  • Identifying and Troubleshooting Poor Cursor Usage
  • Understanding System Threads that Consume CPU
  • Best Practices to prevent CPU bottleneck
  • Internals of Query Parallelism
  • Troubleshooting Query Parallelism Issue
  • What are WAITS and Queues?
  • Troubleshooting WAITS and Queues
  • Uncovering Query Fingerprints and Plan Fingerprints
  • Detecting IO Issues
  • Reviewing Performance Counters to Troubleshoot IO Issues
  • Understanding SQL Server Virtual File Stats
  • Tuning SQL Server to reduce or balance IO Load
  • Data Compression
  • Understanding CHECKPOINTS in SQL Server
  • Flushing Transaction Logs
  • Common causes of IO Issus and their resolution
  • IO Bottlenecks
  • Best Practices for Troubleshooting IO in SQL Server
  • What are latches?
  • How are latches used in SQL Server?
  • Different types of Latch modes
  • Latch Compatibility
  • Understanding Super and Sub Latches
  • Latch Classes
  • How is TempDB Impacted due to Latching?
  • Understanding Allocation Bottleneck
  • Understanding Latch Contention
  • What impacts Latch Contention?
  • Diagnosing Latch Contention
  • Analyzing Current WAIT Buffer Latches
  • Type of WAITS for Executing Sessions
  • Performance impact of T-SQL Operators
  • Internals of Statistics and its selectivity and Cardinality
  • Understanding Query Plans
  • Internals of Common Operators (Joins (Nested Loop Joins, Merge Joins, Hash Joins, Bookmark Lookup, Sort, Table Spool, Aggregates)
  • Common Tips (Missing Indexes, Execution Warnings, Missing Stats Warning, Avoiding Sort, Mismatched Data Type)
  • Common Query Plan Issues
  • Statistics Management
  • Missing Indexes
  • Non-SARGable Predicate
  • Performance Impact of Local variables
  • Issues with Multi-Statement TVF, Table Variables, TVP, Recursive CTE, Row Goals, Data Type Mismatch, Parameter Sniffing
  • Optimizer Time out
  • Working with Large amount of Memory
  • Managing Large Number of Locks
  • Managing and maintaining Large Plan Cache
  • Diagnosing Query Execution Warnings
  • Query Hint Techniques
  • Internals of Plan Guide
  • Indexed Views
  • Partitioned Tables
  • Distributed Query/Linked Server
  • Column Store Index
  • AlwaysOn – Performance feature - Statistics on secondary
  • Performance related tips, tricks and techniques and scripts

Note: This Course Offers Job Assistance, Internship Opportunities and Includes One-Year of Free Access to Class Videos.

Contact Us:

Have questions about this course? Call us @ +1 (404) 800-5359 or Email us @ training@sqloperations.com. Our team of database experts are standing-by to help answer your questions.


SQL Server Training
SQL Developer Course Details
SQL Developer Training Value
Corporate and Onsite Training by SQL Operations
Contact SQL Operations
SQL Operations Services


Home   |   Training   |   Services   |   Risk & Health Audit   |   Career   |   About Us   |   Contact Us
Copyright 2018 by SQLOPERATIONS