Workshops

Instructor
Schedule
Feedbacks
Webcasts
Contacts




Sign up

for Email

Updates


Register for the upcoming 3 Day Level 400 Microsoft SQL Server 2008 Performance Monitoring & Tuning Hands-on Workshop in London, United Kingdom during June 12-14, 2012, click here to register. These are hands-on workshops with a maximum of 12 participants and not lectures. For consulting engagements click here.

To read some of our articles I wrote click here. To watch our free webcasts click here.

R Meyyappan primarily offers 2 types of workshops, 3 Day Level 400 Microsoft SQL Server 2008 Performance Monitoring & Tuning Hands-on Workshop and 3 day Level 300 SQL Server 2008 Administration & Tuning for SAP Customers Hands-on Workshop.

3 Day Level 400 Microsoft SQL Server 2008 Performance Monitoring & Tuning Hands-on Workshop.

  Target Group: Database Administrators, Developers and Database Architects. This workshop is not for SQL Server Trainers or Instructors.

  Goal of the Workshop: To provide the participants with knowledge on how to monitor and tune performance of Microsoft SQL Server 2008. 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 here.

  Prerequisite: 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.

  Instructor: 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 & Troubleshooting.

  Charges: € 2100 (VAT excl.). For Workshop schedule and registration information click here.

  Maximum Attendees per workshop: 12.

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.

 

For details on 3 day Level 300 SQL Server 2008 Administration & Tuning for SAP Customers Hands-on Workshop click here.

 

© 2010 www.sqlworkshops.com. All rights reserved. Terms of Use