36 Scripts: Performance Tricks Jedi Master Wants You to Know

Tuesday May 22 09:00 - 17:00

“Train yourself to let go of everything you fear to lose.” – Yoda

This demo-oriented (story telling narrative) a day-long session will answer the questions which DBA and Developers often wonder about Performance Tuning and Query Optimization. There are some problems which have straight forward answers, but there are some problems which are often invisible or needs attention without even a problem statement. This day-long session will be divided in these three major components

  1. Identifying and resolve common performance tuning patterns and anti-patterns
    • Slow running queries
    • Resource Intensive operations (IO, CPU, and Memory)
    • tempdb contention
    • optimizing execution plan
  2. Proactively resolving optimization bottlenecks and issues
    • Indexing strategies
    • wait stats and queues
    • database file deployment best practices
    • optimizing statistics
  3. Plan ahead for unexpected performance issue while upgraded to the latest version of SQL Server 2014 and 2016
    • New cardinality engine
    • column store indexes best practices
    • live plans
    • azure enhancements
    • in-memory OLTP optimizations
    • query store
    • temporal table

We will discuss 36 different tips and tricks along with scripts in this session and every attendee will have those scripts handy upon completion of the session.

The session will have a unique storytelling style of presentation. We will have a big story arc (an experienced DBA – Jedi with Junior Intern – Padawan) with three sub story lines. We will refer many of the popular quotes from popular culture and build story around it. We will end the session with following statement – “Always pass on what you have learned.” – Yoda

Stay alert for pop quizzes.

Pinal Dave

Pinal Dave is a technology enthusiast and an independent consultant. He has authored 11 SQL Server database books, 21 Pluralsight courses and have written over 3800 articles on the database technology on his blog at a http://blog.sqlauthority.com. Along with 14+ years of hands on experience he holds a Masters of Science degree and a number of database certifications.