Performance Tuning and Optimising SQL Databases

Are you interested in being part of the alpha phase testing group for Spark, our new AI-powered, learning chatbot? Register your interest here.

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.