Liebe Dynamics Partner!
Im November findet ein dreitägiger SQL Performance Workshop in Wien statt. Infos zur Agenda, den Voraussetzungen und weitere Informationen finden Sie untenstehend:
-----------
Achtung, alle Datenbank ExpertInnen! Wie schon letztes Jahr findet auch heuer ein SQL-Performance Tuning Workshop mit Ramesh Meyyappan 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 in einem Monat statt:
von 15. – 17. November 2011
(Achtung, das Datum hier wurde am 7. November korrigiert, siehe auch http://www.sqlworkshops.com/schedule)
Also rasch überlegen!
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 oder registrieren Sie direkt hier: http://www.sqlworkshops.com/registrationaustria7.asp
Die Übersicht zum Training können Sie hier laden (in englischer Sprache):
Level400SQLServerTuningWorkshop.pdf
Viel Spaß!