top of page

Computer Technology


Computer Technology 


Performance Tuning and Optimizing SQL Databases

Performance Tuning and Optimizing SQL Databases

Duration (Days)



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.

  • 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

bottom of page