IBM - Informix Dynamic Server 11 Performance Tuning

PROKODA Gmbh
In Berlin

2.690 
Möchten Sie den Bildungsanbieter lieber direkt anrufen?
0221/... Mehr ansehen

Wichtige informationen

  • Seminar
  • Fortgeschritten
  • Berlin
  • Dauer:
    4 Tage
Beschreibung

IBM - Informix Dynamic Server 11 Performance Tuning: This is an advanced course for experienced Informix Dynamic Server system administrators and database administrators._x000D_. In this course, students will learn the fundamentals of tuning an Informix Dynamic Server instance for optimal performance. The course covers topics related to hardware issues and tuning for..
Gerichtet an: This is an advanced course for experienced Informix Dynamic Server system administrators and database administrators._x000D_. In this course, students will learn the fundamentals of tuning an Informix Dynamic Server instance for optimal performance. The course covers topics related to hardware issues and tuning for optimizing data loads, index builds, UPDATE STATISTICS processes, and OLTP and DSS queries.. A multiprocessor UNIX machine with...

Wichtige informationen
Veranstaltungsort(e)

Wo und wann

Beginn Lage
auf Anfrage
Berlin
Zimmerstr. 79/80, 10117, Berlin, Deutschland
Plan ansehen

Häufig gestellte Fragen

· Voraussetzungen

You should complete: IBM Informix Dynamic Server System Administration (IX811) or (L1846)and IBM Informix Dynamic Server Database Administration - Managing and Optimizing Data (IX221) or (FN848) or equivalent experience

Themenkreis

KURSZIEL
IBM - Informix Dynamic Server 11 Performance Tuning: This is an advanced course for experienced Informix Dynamic Server system administrators and database administrators._x000D_

_x000D_

In this course, students will learn the fundamentals of tuning an Informix Dynamic Server instance for optimal performance. The course covers topics related to hardware issues and tuning for optimizing data loads, index builds, UPDATE STATISTICS processes, and OLTP and DSS queries. _x000D_

_x000D_

A multiprocessor UNIX machine with multiple disk drives will be provided so that students can perform benchmarking exercises to test the tuning skills they have learned.

ZIELGRUPPE
This is an advanced course for experienced Informix Dynamic Server system administrators and database administrators._x000D_

_x000D_

In this course, students will learn the fundamentals of tuning an Informix Dynamic Server instance for optimal performance. The course covers topics related to hardware issues and tuning for optimizing data loads, index builds, UPDATE STATISTICS processes, and OLTP and DSS queries. _x000D_

_x000D_

A multiprocessor UNIX machine with multiple disk drives will be provided so that students can perform benchmarking exercises to test the tuning skills they have learned.

KURSINHALT
Kursziele
  • Describe the performance tuning process
  • Use IDS and UNIX/Linux utilities to aid in performance tuning
  • Optimize performance for data loads
  • Apply techniques to optimize index design and index build performance
  • Optimize collection of the data statistics used by the optimizer in generating the SQL query plan
  • Tune a database for optimum performance of OnLine Transaction Processing (OLTP) workloads
  • Plan and implement fragmentation strategies to best meet workload requirements
  • Optimize parallel queries by tuning Parallel Data Query (PDQ) parameters
Themenübersicht
  • Introduction to Performance Tuning
  • Monitoring Utilities
  • Optimizing Load Performance
  • Index Performance Issues
  • Optimizing UPDATE STATISTICS
  • OLTP Performance Tuning
  • Fragmentation Strategies
  • Managing Query Resources
  • Tuning Client Server Communication
Hinweise
Course material will be in English.


VORRAUSSETZUNG
You should complete:
  • IBM Informix Dynamic Server System Administration (IX811) or (L1846)and
  • IBM Informix Dynamic Server Database Administration - Managing and Optimizing Data (IX221) or (FN848)
  • or equivalent experience

Vergleichen Sie diesen Kurs mit ähnlichen Kursen
Mehr ansehen