Computer Technology

   >

Computer Technology 

   >

Performance Tuning and Optimizing SQL Databases

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