This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Find out more here                     
decoration
decoration
decoration

Super-Scaling SQL Server

10th October 2014 - 1 day course

Who is it for?

This 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.

What you will learn

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.

The course agenda is as follows:  

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

Key Benefits

This course will provide SQL Server professionals with deep insights into performance tuning techniques.

Cost: £499 + VAT (until June 30 2014), 549 + VAT (from July 1 2014) +VAT
decoration

Trainer

Formerly of the SQL CAT Team, Thomas Kejser is now a consultant and entrepreneur. 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.

decoration

Location

Skills Matter
116-120 Goswell Road
decoration

legal disclaimer

Cancellations must be submitted in writing, either via email or by post. Registrants whose cancellations are received at least 2 weeks before the beginning of the course are entitled to a full refund minus a £80 processing fee plus any credit card charges incurred. No refunds will be given to registrants who cancel less than 2 weeks before the beginning of the course or who fail to attend.

In the extraordinary case where the course is cancelled a full refund will be given to all paid registrants. Crossjoin Consulting will not refund any other amount paid by registrants to other companies, including travel expenses and hotel reservations.

decoration
decoration decoration decoration decoration
decoration
decoration