SQLBits encompasses everything from in-depth technical immersions to the enhancement of valuable soft skills. The full agenda will be announced in the spring; in the meantime check out the timetable and content we cover below.
2024 Training Days
Presenting 2024’s selection of training days, encompassing a deep dive into a range of subjects with some of the best data trainers in the world.
- 08:00 Registration opens and breakfast served.
- All training days run simultaneously across the venue from 09:00 – 17:00 with co-ordinated breaks.
- All training days include regular refreshment breaks and a lunch stop to rest, recharge, and chat to fellow delegates.
- No evening events planned, but if you’re staying over the night beforehand, why not join us in the Aviator on Monday night to meet the training day speakers for an informal drinks reception.
Practical SQL Server Performance Troubleshooting & Tuning
Description
Overview
Practical SQL Server Performance Troubleshooting & Tuning Pre-Con is designed for the working SQL Server professionals, Developers, Database Administrators & Architects who have relevant experience with SQL Server and only needs practical examples of performance troubleshooting & tuning that can be applied in applications & production right away. In this full-day training, participants will see relevant, crisp, real-world examples of tuning SQL Server performance.
An 8-hour, 100% demo-oriented delivery on SQL Server Performance Troubleshooting & Tuning. Basic to Intermediate level, covering important aspects.
Module 1: SQL Server Wait Types & Statistics
Query Lifecycle
Connections -> Sessions -> Requests -> Tasks -> Workers -> Threads
Common Wait Types in SQL Server, identification & diagnosis
Module 2: The Holy Trinity – CPU, Memory, IO
Identifying, troubleshooting & tuning workload patterns that cause excessive CPU
Identifying, troubleshooting & tuning workload patterns that cause excessive Memory Usage
Identifying, troubleshooting & tuning workload patterns that cause excessive IO
Module 3: Query Execution & Query Plan Analysis
Statistics & Cardinality Estimation
Reading & Analysing Execution Plans
Important Iterators
Module 4: Query Tuning
Rewriting Transact-SQL
Optimizing Stored Procedures
Solving Parameter Sniffing Issues
Parametrization Best Practices
Tips with Procedural Code
Module 5: Index Tuning
Demystifying Common Myths with Indexes
Indexing Strategies
Index Fragmentation
Real-World Index Tuning Examples
Module 6: Dealing with Deadlocks
SQL Server Concurrency, Isolation Levels, Locking Granularity & Hierarchy
Common Deadlock Types
Deadlock Best Practices
Practical Deadlock Troubleshooting & Diagnosis
Pre-Con Takeaways:
Practical, Real-World Examples
All Demo Scripts
Loads of learning that can be applied into production right-away
Additional Notes:
Most training programs lack real-world examples. In this pre-con, an attendee will learn real world performance troubleshooting & tuning skills with SQL Server. Emphasis is on real-world & practical skills.
Pre-Con will be fast paced. 100% Demo-oriented. Attendees are requested to pay full attention to the instructor and the demos.
Laptops & mobile phones off. All demo codes & labs will be provided to practice later.
Pre-Requisites:
At least two years of genuine working experience with SQL Server
Anything Else?
I have delivered this content multiple times over the years. I recently delivered this pre-con at SQL Saturday Denmark. The whole-day training is delivered by simulating performance issues and then fixing them. Very practical & real-world. 100% Demo-oriented. Pre-Con will be fast paced.
Denmark feedback Other Testimonials
Practical SQL Server Performance Troubleshooting & Tuning Pre-Con is designed for the working SQL Server professionals, Developers, Database Administrators & Architects who have relevant experience with SQL Server and only needs practical examples of performance troubleshooting & tuning that can be applied in applications & production right away. In this full-day training, participants will see relevant, crisp, real-world examples of tuning SQL Server performance.
An 8-hour, 100% demo-oriented delivery on SQL Server Performance Troubleshooting & Tuning. Basic to Intermediate level, covering important aspects.
Module 1: SQL Server Wait Types & Statistics
Query Lifecycle
Connections -> Sessions -> Requests -> Tasks -> Workers -> Threads
Common Wait Types in SQL Server, identification & diagnosis
Module 2: The Holy Trinity – CPU, Memory, IO
Identifying, troubleshooting & tuning workload patterns that cause excessive CPU
Identifying, troubleshooting & tuning workload patterns that cause excessive Memory Usage
Identifying, troubleshooting & tuning workload patterns that cause excessive IO
Module 3: Query Execution & Query Plan Analysis
Statistics & Cardinality Estimation
Reading & Analysing Execution Plans
Important Iterators
Module 4: Query Tuning
Rewriting Transact-SQL
Optimizing Stored Procedures
Solving Parameter Sniffing Issues
Parametrization Best Practices
Tips with Procedural Code
Module 5: Index Tuning
Demystifying Common Myths with Indexes
Indexing Strategies
Index Fragmentation
Real-World Index Tuning Examples
Module 6: Dealing with Deadlocks
SQL Server Concurrency, Isolation Levels, Locking Granularity & Hierarchy
Common Deadlock Types
Deadlock Best Practices
Practical Deadlock Troubleshooting & Diagnosis
Pre-Con Takeaways:
Practical, Real-World Examples
All Demo Scripts
Loads of learning that can be applied into production right-away
Additional Notes:
Most training programs lack real-world examples. In this pre-con, an attendee will learn real world performance troubleshooting & tuning skills with SQL Server. Emphasis is on real-world & practical skills.
Pre-Con will be fast paced. 100% Demo-oriented. Attendees are requested to pay full attention to the instructor and the demos.
Laptops & mobile phones off. All demo codes & labs will be provided to practice later.
Pre-Requisites:
At least two years of genuine working experience with SQL Server
Anything Else?
I have delivered this content multiple times over the years. I recently delivered this pre-con at SQL Saturday Denmark. The whole-day training is delivered by simulating performance issues and then fixing them. Very practical & real-world. 100% Demo-oriented. Pre-Con will be fast paced.
Denmark feedback Other Testimonials
Learning Objectives
Previous Experience
Tech Covered
performance, memory, troubleshooting, tuning, Database, SQL, SQL Server