W dniach 16-18 lutego w Helsinkach (Finlandia), oraz 12-14 kwietnia i 14-16 czerwca w Wiedniu (Austria) odbędą się zaawansowane technicznie warsztaty na temat monitorowania i dostrajania wydajności i produktywności SLQ Server 2005 i 2008. Wszystkie edycje warsztatów organizowane są przy udziale lokalnych oddziałów Microsoft (odpowiednio Finland i Austria). Liczba uczestników jest ograniczona do dwunastu, zaś docelową grupą odbiorców są administratorzy, programiści i architekcji baz danych. Instruktorem na tych warsztatach będzie Ramesh Meyyappan (krótkie bio w języku angielskim: Microsoft SQL Server specialist with expertise in Performance Monitoring, Tuning & Troubleshooting. He is also specialized in Managing & Optimizing SQL Server Implementation for SAP Customers. Furthermore, Ramesh conducts workshops on SQL Server 2008 and SQL Server 2005 Performance Monitoring & Tuning as well as workshops on SQL Server 2008 and SQL Server 2005 Administration & Tuning for SAP Customers).
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.
Więcej informacji znaleść można pod poniższymi linkami:
3 Day Level 400 Microsoft SQL Server 2008 and SQL Server 2005 Performance Monitoring & Tuning Workshop | Helsinki, 16-18 lutego 2010
3 Day Level 400 Microsoft SQL Server 2008 and SQL Server 2005 Performance Monitoring & Tuning Workshop | Wiedeń, 12-14 kwietnia 2010
0 Comments.