Gå til innhold
FAG – KURS OG KONFERANSER

MS 10987: Performance Tuning and Optimizing SQL Databases

This four-day instructor-led course provides students who manage and maintain SQL Server databases with the knowledge and skills to performance tune and optimize their databases.

Påmelding gjennom glasspaper

Påmelding Glasspaper

Prerequisites:

In addition to their professional experience, students who attend this training should already have the following technical knowledge:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of database administration and maintenance.
  • Working knowledge of Transact-SQL.

Course goals:

After completing this course, students will be able to:

  • Describe the high level architectural overview of SQL Server and its various components.
  • Describe the SQL Server execution model, waits and queues.
  • Describe core I/O concepts, Storage Area Networks and performance testing.
  • Describe architectural concepts and best practices related to data files for user databases and TempDB.
  • Describe architectural concepts and best practices related to Concurrency, Transactions, Isolation Levels and Locking.
  • Describe architectural concepts of the Optimizer and how to identify and fix query plan issues.
  • Describe architectural concepts, troubleshooting scenarios and best practices related to Plan Cache.
  • Describe architectural concepts, troubleshooting strategy and usage scenarios for Extended Events.
  • Explain data collection strategy and techniques to analyze collected data.
  • Understand techniques to identify and diagnose bottlenecks to improve overall performance.

 Read complete course description:
https://www.microsoft.com/en-us/learning/course.aspx?cid=10987

Certification:

There is no certification related to this course.

Kurset arrangeres i samarbeid med:

Logo_Glasspaper

Bli medlem i NITO

Gjør som over 86.000 andre ingeniører og teknologer. Med gode medlemsfordeler får du mer å rutte med i hverdagen.

Ordinær fagforeningskontingent er fradragsberettiget. For 2018 kan du trekke fra inntil kr. 3850,- i din skattepliktige inntekt!

Bli medlem i dag