|
Registration for June 12-14, 2012 Workshop in London, United Kingdom
3 Day Level 400 Microsoft SQL Server Performance Monitoring
& Tuning Hands-on Workshop.
Target Group:
Database Administrators, Developers and Database
Architects. This workshop is not for SQL Server Trainers or
Instructors.
Date: June 12-14, 2012.
Maximum Attendees per workshop:
12.
Charges: £ 1800 (VAT excl.). Early bird discount of £125 until
11 May
Location: London City, United Kingdom.
Organized by SQL Consulting GmbH.
To read some of our articles I wrote click
here. To watch our free webcasts
click
here. 
Your registration can be confirmed only after we
receive your payment.
Goal of the Workshop:
To provide the participants with knowledge on how to
monitor and tune performance of Microsoft SQL Server. 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.
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.
|
