Press esc to close
Press esc to close
Fill out your contact details below and our training experts will be in touch.
If you wish to make any changes to your course, please log a ticket and choose the category ‘booking change’
Back to Course Information
This training course will cover the following modules:
Module 1: SQL Server Architecture, Scheduling, and Waits
SQL Server Components and SQL OS
Windows Scheduling vs SQL Scheduling
Waits and Queues
Lab: SQL Server Architecture, Scheduling, and Waits
Module 2: SQL Server I/O
I/O Setup and Testing
Lab: Testing Storage Performance
Module 3: Database Structures
Database Structure Internals
Data File Internals
Lab: Database Structures
Module 4: SQL Server Memory
SQL Server Memory
Lab: SQL Server Memory
Module 5: SQL Server Concurrency
Concurrency and Transactions
Lab: SQL Server Concurrency
Module 6: Statistics and Index Internals
Statistics Internals and Cardinality Estimation
Lab: Statistics and Index Internals
Module 7: Query Execution and Query Plan Analysis
Query Execution and Optimizer Internals
Query Execution Plans
Analyzing Query Execution Plans
Lab: Query Execution and Query Plan Analysis
Module 8: Plan Caching and Recompilation
Plan Cache Internals
Troubleshooting Plan Cache Issues
Lab: Plan Caching and Recompilation
Module 9: Extended Events
Extended Events Core Concepts
Working with Extended Events
Lab: Extended Events
Module 10: Monitoring, Tracing, and Baselining
Monitoring and Tracing
Data Collection Strategy
Baselining and Benchmarking
Lab: Monitoring, Tracing, and Baselining
This course is designed for those who administer and maintain SQL Server databases, manage the performance of SQL Server instances, and write queries against data. Likewise, this course is intended for individuals who develop applications that produce data from SQL Server databases. Therefore, IT Professionals in particular would benefit from this Performance Tuning and Optimizing SQL Databases training course.
In order to attend this course, delegates should possess some professional experience and knowledge of the following:
Microsoft Windows operating system and its key functions
Database administration and maintenance
This Microsoft SQL Server training course provides delegates with the knowledge and techniques needed to optimise and monitor the performance of their databases.
During this 4 day course, delegates will become familiar with the functionalities of SQL Server, and will explore its fundamental concepts, including the execution model, waits, and queues. The architectural concepts and best practices relating to data files, transactions, locking, concurrency, and solving query plan problems will be explored. As well as this, the elements and strategy of the plan cache and extended events will be studied.
By the end of this Performance Tuning and Optimizing SQL Databases training course, delegates will be able to explain data collection strategy, identify techniques for data analysis, and determine where improvements can be made to enhance overall performance.
The Knowledge Academy is a Microsoft Silver Partner, therefore we are an accredited provider of Microsoft training courses.
There is no associated exam for Performance Tuning and Optimizing SQL Databases.
Why choose us
Our easy to use Virtual platform allows you to sit the course from home with a live instructor. You will follow the same schedule as the classroom course, and will be able to interact with the trainer and other delegates.
Our fully interactive online training platform is compatible across all devices and can be accessed from anywhere, at any time. All our online courses come with a standard 90 days access that can be extended upon request. Our expert trainers are constantly on hand to help you with any questions which may arise.
Course was run very smoothly, Richard our trainer was extremely knowledgeable and delivered the course in a succinct fashion with a twist of humour thrown in.
The course was great and the so was the trainer - brilliantly delivered and I would certainly recommend this course to my colleagues. Thanks to Richard for a great course and delivering it a tough environment virtually.
Richard was very knowledgeable and explained well
You won't find better value in the marketplace. If you do find a lower price, we will beat it.
Microsoft Gold Learning Partner
Flexible delivery methods are available depending on your learning style.
Resources are included for a comprehensive learning experience.
"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"
Joshua Davies, Thames Water