3 Day Level 400 Microsoft SQL Server Performance Monitoring
& Tuning Hands-on Workshop.
Database Administrators, Developers and Database
Architects. This workshop is not for SQL Server Trainers or
Date: February 27-March 01, 2013.
Maximum Attendees per workshop:
Charges: Euro 2100 (VAT excl.). LinkedIn SQL Server User Group
Finland members pay Euro 1950 (VAT excl.).
Location: Microsoft Oy, Keilaranta 7, 02150 Espoo.
To read some of our articles I wrote click
here. To watch our free webcasts
Your registration can be confirmed only after we
receive your payment.
Goal of the Workshop:
To provide participants with
knowledge on how to monitor and tune performance of Microsoft
SQL Server 2012 and 2008. The course addresses CPU, Memory,
Disk, Query and Lock monitoring and tuning techniques for
optimal performance and to maximize the utilization of existing
hardware. 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
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.
R Meyyappan with more than 15 years of SQL Server
expertise including working in the past as a Program Manager in
the SQL Server Development Team at Microsoft Corporation. He is
specialized in SQL Server Performance Monitoring, Tuning &
Analyzing current activity and performance bottlenecks of SQL Server in a Production environment:
This module introduces a comprehensive approach for
analyzing current performance bottlenecks of SQL Server in a
Monitoring and Tuning CPU Utilization:
SQL Server architecture relating to CPU usage is explained. Efficient methods for monitoring and tuning CPU bottlenecks are described. Identifying optimal number of CPUs and configuration parameters for maximizing CPU utilization is explained. Best practice guidelines on using Resource Governor for allocating CPU resource are covered.
Monitoring and Tuning Disk I/O and Database Files:
SQL Server architecture relating to Disk I/O and Database File usage are explained. Various methods including Wait Stats and Extended Events for monitoring Disk I/O and Database File usage are described out of which few important methods with reference data are provided for optimal monitoring. Best practice guidelines on implementing Storage subsystems with DAS, SAN and SSDs are explained. Configuring and maintaining Database Files for user database and tempdb with Index Rebuild and Reorganization, 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 for monitoring and tuning memory usage are described. Tempdb usage due to Memory pressure and suboptimal execution plans are explained along with effective workarounds to address these performance issues. Best practice guidelines on using Resource Governor for optimizing Memory usage are covered.
Monitoring and Tuning Query Optimization and Query Execution:
SQL Server architecture relating to Query Optimization and Query Execution is explained. Various methods for monitoring and tuning Plan Caching and Recompilation using Parameterization and Plan Guides are described. Analyzing Execution Plans including joins and parallel plans and isolating performance issues are described. Monitoring and tuning Query Execution with optimal Indexes, Statistics, Query Hints, Computed Columns, Indexed Views, Filtered Indexes, Filtered Statistics, Indexed Views, Partitioned Tables and Partitioned Views are covered. Best practice guidelines on using Temporary Tables, Table Variables, Table Value Parameters, Stored Procedures, User Defined Functions and in general writing SQL Server Query Optimizer friendly queries are covered.
Monitoring and Tuning Locks, Deadlocks and other Concurrency
SQL Server architecture relating to resource Locking is explained. Various methods including Extended Events for monitoring and tuning Locking, Blocking and Deadlocks are described. Best practice guidelines on using Snapshot Isolation level, disabling Table Lock Escalation, and Locking Hints and query rewrite procedures to reduce locking and deadlocks issues are covered.
Monitoring and Tuning AlwaysOn Availability Groups, Database Mirroring, Database Replication, Columnstore Indexes, Backup Compression and Database Encryption:
Monitoring and tuning the performance impact of Availability Replicas, Database Mirroring is explained. Best practice guidelines on using Database Replication, Columnstore Indexes, Backup Compression, and Database Encryption from performance perspective are covered.
Useful Performance data to collect on a regular interval and
on ad-hoc basis are discussed. Using Extended Events and
Management Data Warehouse for performance data collection is
explained. Ways to further deepen the SQL Server performance
monitoring and tuning knowledge is discussed.