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!
Configure database physical storage and filegroups.
Detect and optimize common poorly performing coding practices.
Troubleshoot and optimize locking and concurrency issues.
Manage database compression.
Mantain database for optimal performance.
Troubleshoot common virtualization problems.
Optimize data loading.
Optimize and mantain statistics.
Read, unterstand and toubleshoot complex execution plans.
Course Delivery Options
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.
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.
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.
Module 1. SQL Architecture
Module 2. SQL Server Performance Monitoring Tools
Module 3. CPU and Scheduling
Module 4. SQL Server Memory
Module 5. SQL Server IO
Module 6. Query Optimization and
Module 7.SQL Server Indexes and Query Plan Analysis
Module 8. SQL Server Concurrency
Module 9. SQL Server In-Memory Technologies
Do you want more info about these courses?