Advance Performance Tuning Workshop

We all know the situation only too well, Friday evening and the weekend is flirting with you promisingly ….. then the dreaded email arrives telling you that your SQL Server has enormous performance problems. What can you do to identify the problem and resolve it quickly? Which SQL Server tools will help you rescue your free time?

In this 4-Day workshop Klaus will:

  • Delve into the most prominent performance bottlenecks inside SQL Server
  • Show you the different tools at your disposal to enable effective SQL Server performance troubleshooting.
  • Teach you how to identify and resolve performance bottlenecks quickly.

Who should attend?

Database Administrators, Developers and SQL Professionals seeking advanced troubleshooting techniques.

Pre-requisites

  • Experience running SQL Server
  • Fundamental index tuning and queryplan analysis skills
  • Basic understanding of operating system

Course Agenda

Day 1:

    Database Internals
  • Structures
  • Fixed Length Data Types
  • Variable Length Data Types
  • Sparse Columns
  • LOB Columns
  • Data Modification

    Execution Plans
  • Understanding Execution Plans
  • Physical Operators
  • Plan Generation & Caching
  • Plan Reuse & Recompilations
  • Plan Cache Pollution
  • Parameter Sniffing

Day 2:

    Indexing
  • Table Scan/Index Scan/Index Seek
  • Clustered/Non-Clustered Indexes
  • Bookmark Lookups
  • Index Intersection
  • Filtered Indexes
  • Indexed Views
  • Page Fragmentation
  • Page Splits
  • Fill Factor
  • Searchable Arguments
  • Index Maintenance

    Statistics
  • Overview
  • Working with Statistics
  • Multi-Column Statistics
  • Statistics Maintenance

Day 3:


    Deadlocking
  • Detection
  • Avoidance
  • Deadlocking Types
  • Troubleshooting

    Latches
  • Lash Architecture
  • Lash Types
  • Lash Modes
  • Hash Partitioning
  • Spinlocks
  • Troubleshooting

Day 4:

  • Performance Monitoring Methodology
  • PAL Tools
  • Windows Performance Monitor
  • SQL Server Profiler
  • Establishing a Baseline
  • Wait Stats
  • OS & Storage Configuration
  • Database Configuration
  • Memory Management
  • Parallelization
  • TempDb

Dates: September 30th, October 1st, 2nd, 3rd

Veune: Dublin – venue TBC

Cost: €1,990 (Early Bird until February 28th 2012 €1,790)

For further information contact: events@prodata.ie or call 01 2933883

Register Now

Speakers

Sponsors

  • Prodata SQL Centre of Excellence

Other Information