Super-scaling SQL Server

This course is not for the faint-hearted…. In fact you could describe it as performance tuning on steroids. In one intense day, Thomas will take participants beyond indexes to the next steps in optimising the performance of their SQL Servers. It aims to take you beyond best practices, below the surface into the realm of measurement and KNOWLEDGE about why your implementation works or doesn’t.

You will learn how to use xPerf and xEvents to scientifically measure, diagnose and resolve performance and scalability issues, covering both SQL Server and the code that accesses the database.

While the curriculum assumes you already familiar with basic indexing strategies and query tuning, you will learn more about the internals of query execution and good join strategies. The course will cover tuning patterns that you can apply to proactively make your designs scalable before any nasty surprises happen.

The course will provide insights into spinlocks, latching, hardware-specific tricks and other more obscure areas of SQL Server so you are armed to take on the hardest tuning challenges.

Who should attend?

The course is level 400+ and targets the sweet spot between designing for performance and maintaining performance and is therefore relevant to Architects, Developers and DBAs alike, and as for Consultants… you will be guaranteed a brand new power-tool in the tool box.

Pre-requisites

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

Course Agenda

    Module 1:
  • Single Threaded Optimisation
  • Workload Classification
  • Join algorithms (re)visited
  • Query pattern and expected behaviours
  • Measuring CPU time and basic Xperf skills
    Module 2:
  • Stack walking and symbol resolution
  • Classifying time outside the database (.NET and other code)
  • Digging into strange wait types
  • Getting I/O right
  • Getting Networking right
    Module 3:
  • Multi threaded Optimisation
  • Thread Bottlenecks and shared context
  • Allocations and transaction log file optimisation
  • Spinlocks and classification
  • What is CXPACKET? When should you worry?
  • Avoiding shared context in SQL Server
    Module 4:
  • Advanced Xperf Configuration
  • Bad Drivers: Troubleshooting DPC/ISR issues
  • Affinity masks and cache coherency
  • NUMA optimisations

Dates: Friday 23rd November 2012

Veune: Dublin – venue TBC

Times:

  • 09.00 – 11.00 Module 1

  • 11.00 – 11.15 Coffee

  • 11.15 – 13.00 Module 2

  • 13.00 – 14.00 Lunch

  • 14.00 – 16.00 Module 3

  • 16.00 – 16.15 Coffee

  • 16.15 – 18.00 Module 4

Cost: €699 (Early Bird until September 30th 2012 - €599)

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

Register Now

Speakers

  • Thomas Kejser

    Thomas Kejser

    Formerly of the SQL CAT Team, Thomas is now CTO of Fusion IO. Building multi-terabyte- sized data warehouses, setting up OLTP systems for extreme scale and tuning world record data movement speed are some of Thomas’ recent achievements. . His blog can be found at http://blog.kejser.org/about/

Sponsors

  • Prodata SQL Centre of Excellence
  • Microsoft

Other Information