Home Specialist skills Technology and Software Performance Tuning and Optimising SQL Databases
Performance Tuning and Optimising SQL Databases
-
Gain a high-level architectural overview of SQL Server and its various components
-
Describe core input/output concepts, storage area networks and performance testing
-
Describe architectural concepts and best practices related to concurrency, transactions, isolation levels and locking
-
Describe architectural concepts, troubleshooting scenarios and best practices related to plan cache
-
Understand techniques to identify and diagnose bottlenecks to improve overall performance
Overview
Off the shelf (OTS)
This official Microsoft 4-day instructor-led course provides learners who manage and maintain SQL Server databases with the knowledge and skills to know how to optimise and tune SQL database performance.
Delivery method
Face to face
Virtual
Course duration
30 hours
Competency level
Foundation
Delivery method
-
Face to face
-
Virtual
Course duration
30 hours
Competency level
-
Foundation