Microsoft Partner Network

Microsoft SQL Server Performance Monitoring und Tuning Workshop im November

Martin-Pockl   13. Oktober 2011 22:36 Kommentare (0) Tags:  Feed Tag

Achtung an alle Datenbank ExpertInnen! Wie schon letztes Jahr findet auch heuer wieder ein SQL Server Performance Tuning Workshop mit Ramesh SQL08R2-Ent_h_rgbMeyyappan bei Microsoft in Wien statt!

“3 Days Level 400 Microsoft SQL Server 2008 and SQL Server 2005 Performance Monitoring & Tuning Workshop”

Der Trainer Ramesh Meyyappan ist ausgewiesener SQL Experte. Als Program Manager im Microsoft SQL Server Development Team hat Ramesh mehr als 15 Jahre Erfahrung mit SQL Server Performance Monitoring, Tuning und Troubleshooting.

Die Agenda:

  • Analyzing current performance bottlenecks of a SQL Server in a Production environment:
    This module introduces a comprehensive approach for analyzing current performance bottlenecks of SQL Server in a Production environment.
  • Monitoring and Tuning CPU Utilization:
    SQL Server architecture relating to CPU usage is explained. Optimal methods to monitor and tune CPU bottlenecks are described. Best practice guidelines on using Resource Governor are covered.
  • Monitoring and Tuning Disk I/O and Database Files:
    SQL Server architecture relating to Disk I/O and Database File usage is explained. Various methods including Extended Events to monitor Disk I/O and Database File usage is described. Best practice guidelines on implementation and maintenance of Disk subsystem and Database Files, Data Compression, Database Snapshots and Bulk Inserts for optimal performance are covered.
  • Monitoring and Tuning Memory Utilization:
    SQL Server architecture relating to Memory allocation and usage is explained. Efficient methods to monitor and tune Memory usage are described. Best practice guidelines on using Resource Governor are covered.
  • Monitoring and Tuning Query Optimization and Query Execution:
    SQL Server architecture relating to Query Optimization is explained. Various methods to monitor and tune Plan Caching and Recompilation are described. Analyzing Execution Plans and isolating performance issues are described. Monitoring and tuning Query Execution with optimal Indexes, Filtered Indexes, Indexed Views and Partitioned Tables are covered.
  • Monitoring and Tuning Locks, Deadlocks and other Concurrency issues:
    SQL Server architecture relating to resource Locking is explained. Various methods including Extended Events to monitor and tune Locking, Blocking and Deadlocks are described. Best practice guidelines on using Snapshot Isolation level, disabling Table Lock Escalation and Locking Hints are covered.
  • Monitoring and Tuning Database Mirroring, Backup Compression and Database Encryption:
    Monitoring and tuning the performance impact of Database Mirroring is explained. Best practice guidelines on using Backup Compression and Database Encryption are covered.

Die Ziele:

Monitoring und Performance-Tuning von SQL Server.
“The goal of this workshop is to provide the participants with knowledge on how to monitor and tune performance of Microsoft SQL Server 2008 and SQL Server 2005. The course addresses CPU, Memory, Disk, Query and Lock monitoring and tuning techniques. Best practice guidelines for configuration and maintenance are covered. After the workshop, the attendees should be able to identify and tune performance issues. Past workshop feedbacks are available at http://www.sqlworkshops.com/feedbacks.”

Die Voraussetzungen:

Der Workshop findet in englischer Sprache statt, Wissen über Clustering, Heap und Non-cluster-Indexing, Database Engine, Tuning Wizard, SQL Profiler, etc. wird vorausgesetzt!
“This is an advanced workshop; basic SQL Server concepts will not be covered. Prior basic SQL Server experience (knowledge about Cluster, Heap and Non-cluster indexes, Database Engine Tuning Advisor, SQL Profiler) is necessary.”

Der letzte Termin in diesem Jahr in Österreich findet von 15. bis 17. November 2011 statt
(siehe auch http://www.sqlworkshops.com/schedule)

Seminarort und -kosten:

Microsoft Österreich, Am Euro Platz 3, 1120 Wien, www.microsoft.com/austria. Die Kosten für den 3-Tages-Workshop betragen 2.100,- exkl. USt. pro Person. Der Workshop findet ab 6 Teilnehmern statt.

Für eine Anmeldung senden Sie bitte eine email an atsop@microsoft.com mit dem gewünschten Datum oder kontaktieren Sie Ihren Technical Account Manager (TAM).

Die Übersicht zum Training finden Sie hier: Level400SQLServerTuningWorkshop.pdf

Viel Spaß beim Tunen!

Martin Pöckl
martin.poeckl@microoft.com

Kommentar schreiben

biuquote
  • Kommentar
  • Live Vorschau
Loading

Datenschutzhinweis: Sie stimmen durch "Kommentar speichern" der Speicherung Ihrer Angaben durch Microsoft Österreich für die Beantwortung der Anfrage zu. Sie erhalten dadurch keine unerwünschten Werbezusendungen. Ihre Emailadresse wird auf Ihren Wunsch dazu verwendet Sie über neue Kommentare zu informieren.

Microsoft respektiert den Datenschutz. Datenschutz & Cookies