Back To Top

MS SQL Server 2008 - Optimierung und Tuning

DruckansichtDruckansicht

  • Dauer:
    3 Tage
  • Zielgruppe:
    Teamleiter
  • Vorkenntnisse:
    This course is intended for current professional database developers who have three or more years of on-the-job experience developing SQL Server database solutions in an enterprise environment.
  • Methode:
    Vortrag mit Beispielen und Übungen.
  • Typ:
    Öffentliches Seminar / Inhouse
  • Kursnummer:
    1010361
  • Allgemeine Hinweise:
    Entspricht "MOC 50400 - Designing, Optimizing, and Maintaining a Database Solution for SQL Server 2008". Durchgeführt von einem Microsoft Certified Trainer (MCT)
  • Download
    Anmeldeformular | AGB | Info-Broschüre
Themen:
This three-day instructor-led workshop provides database developers working in enterprise environments using Microsoft SQL Server the knowledge and skills to evaluate and improve queries and query response times. The workshop focuses on systematic identification and optimization of database factors that impact query performance.

Inhalte

A. Measuring Database Performance

Importance of Benchmarking - Key Measures for Query Performance: Sysmon - Key Measures for Query Performance: Profiler - Guidelines for Identifying Locking and Blocking

B. Optimizing Physical Database Design

Performance Optimization Model - Schema Optimization Strategy: Keys - Schema Optimization Strategy: Responsible Denormalization - Schema Optimization Strategy: Generalization

C. Optimizing Queries for Performance

Performance Optimization Model: Queries - What Is Query Logical Flow? - Considerations for Using Subqueries - Guidelines for Building Efficient Queries

D. Refactoring Cursors into Queries

Performance Optimization Model: Query-Set-based solutions - Five Steps to Building a Cursor - Strategies for Refactoring Cursors

E. Optimizing an Indexing Strategy

Performance Optimization Model: Indexes - Considerations for Using Indexes - Best Uses of the Clustered Index - Best Practices for Non-Clustered Index Design - How to Document an Indexing Strategy

F. Managing Concurrency

Performance Optimization Model: Locking and Blocking - Multimedia - "How to Use Efficient Queries to Reduce Locking and Blocking" - Strategies to Reduce Locking and Blocking

Dozent:
Marco Skulschus studied economics in Wuppertal, Germany and Paris, France, graduating with a diploma thesis on semantic modeling in XML data. His work at Comelio, both in the seminar as well as in the project sector, concentrates on consulting in the reporting and expert systems focused on social science surveys for management decision making. He was awarded a prize for developing a highly innovative expert system in the construction industry, funded by the German Ministry of Economics and in cooperation with the University of Munich. In addition to his now seven years as a speaker in seminars and lectures, Skulschus shares his knowledge published in books and computer journal articles. Apart from publishing an extensive list of books, many of which focusing on XML, Marco Skulschus is a Microsoft Certified Trainer, Microsoft Certified Application Designer and Oracle Certified Associate and has completed the ComptiaCTT+ exam.