SQL Server – Performance Tuning & Troubleshooting 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 3-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: Performance Tuning with Indexing


    Database Internals
  • Structures
  • Fixed Data Types
  • Variable Length Data Types
  • Data Modification Internals

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

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

    Statistics
  • Overview
  • Working with Statistics
  • Statistics Maintenance

Day 2: Troubleshooting Locking & Blocking


    Troubleshooting Locking
  • Viewing Locks / Lock Granularity / Lock Hierarchy / Lock Escalation / Lock Compatibility / Lock Manager Internals
  • Dynamic Management Views

    Latches
  • Architecture / Types / Modes / Hash Partitioning

Day 3: Performance Monitoring & Troubleshooting

  • Performance Monitoring Methodology
  • PAL/RML Utilities
  • Wait Stats
  • SQL Server Profiler & Perfmon
  • OS & Storage Configuration
  • Database Configuration
  • Memory Management
  • Parallelization
  • TempDb

Dates: November 14th, 15th & 16th

Veune: Dublin – venue TBC

Cost: €1,799 (Early Bird until September 30th 2012 €1,500)

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

Register Now

Speakers

Sponsors

  • Prodata SQL Centre of Excellence
  • Microsoft

Other Information