
Computer Technology
Performance Tuning and Optimizing SQL Databases
Duration (Days)
4
Overview
This course is designed to provide participants the knowledge on how to manage and maintain SQL server databases by performing tune and to optimise databases. They will learn about I/O concepts, storage area network and how to perform testing.
Objectives
-
Learn the high level architectural overview of SQL server and its components
-
Understand the SQL server execution model, waits and queues
-
Understand core I/O concepts, storage area networks and performance testing
-
Understand architectural concepts and practices related to concurrency, transactions, isolation levels and locking
-
Learn the architectural concepts, troubleshooting scenarios and best practices linked to plan cache
-
Analyse collected data by implement the right data collection strategy
Course Outline
-
SQL server architecture
-
SQL server scheduling
-
SQL server waits
-
SQL server I/O
-
Database structures
-
SQL server memory
-
SQL server concurrency
-
Statistics
-
Index
-
Query execution
-
Query plan analysis
-
Plan caching
-
Plan recompilation
-
Extended events
-
Baselining
-
Monitoring
-
Tracing