Hello Dear Reader!  Would you like to attend a class where I'm teaching about all the wonderful SQL Goodness that you've been reading about on my Blog?  Here's your chance!

Pragmatic Works Performance Tuning and Internals Boot Camp 500 Level
Lead by SQL Server MVP Bradley Ball & SQL Server MCM & MVP Jason Horner
Minneapolis Minnesota
One FULL WEEK for $2,995
See the Full Agenda for the Class below!
9/28/2015 - 10/2/2015

PASS SUMMIT 2015 Pre-con
Optimize "All Data" with a Modern Data Warehouse Solution
Lead by SQL Server MVP Bradley Ball & Sr. Consultant Joshua Luedeman
Seattle Washington
One FULL DAY for $459

Most of the world’s data exists in a combination of on-premise, cloud, and non-relational forms. This session teaches you the options, best practices, and patterns to acquire, store, process, and analyze all forms of data in a  modern solution. This solution combines your on-premise systems, cloud solutions, and analytics platforms in a next-generation approach to managing the data life cycle. 

This pre-conference session includes hands-on labs and demos, great take-home content, and up-to-the-minute, “from the field” guidance on how to approach challenges by combining new features and technologies with your expertise as a data pro. We use SQL Server, Apache Hadoop, Microsoft Azure, Azure Machine Learning, and Azure Data Factory--and some other things we can’t discuss yet!


SQL LIVE360 SQL Internals, Optimization, and Indexing Deep Dive
Lead by SQL Server MVP Bradley Ball
Orlando Florida
One Full Day for $550.00

Congratulations you're a SQL Server DBA/Developer/BI Developer. How does SQL Server work? We have tables, views, and indexes. We write queries. How do the queries and the tables work together? Have you ever wondered? Why should you? Understanding how SQL Server works internally helps you understand how and when to use SQL Server to solve business problems. We need to understand the relational engine, index, transaction log, data, and locking internals. We need to know how these apply to business decisions that we make every day! Most importantly we need demos! Join SQL Server MVP Bradley Ball as we dive into the SQL Server Internals spanning from the Query Processor, through the Storage Engine, the Plan Cache and everything in between.
You will learn:
  • Five key areas that will give hands on learning and key concepts or why an attendee should understand Internals and how they apply to every day administration and maintenance of SQL Servers
  • A deeper understanding of the query optimizer, plan cache, and indexes to deliver better performing queries
  • How locking, blocking, and deadlocks affect SQL Server performance. Plus how to identify and fix them

Pragmatic Works Performance Tuning and Internals Boot Camp 500 Level


    Day 1

  1. Houston, do we have a Problem?
SQL Server like any other application in the world is prone to performance issues. As DBAs, it is critical that we understand how and why we need to identify and resolve these issues. In this introductory session, we'll walk through the how and the why of performance tuning, along with discussing the skills to communicate your efforts to your peers.
  1. Performance and Troubleshooting Methodology
The first step to any success in performance tuning and troubleshooting process is having a methodology. Any methodology needs to be able to first address what is slowing down SQL Server and how we can make it better. One of the most effective methodologies is the waits and queues methodology. In this section, we'll review this methodology and review some key wins and pitfalls associated with this methodology.
  1. Investigating and Tracing in SQL Server (Extended Events)
Once performance issues are identified through the waits and queues methodology, you will be aimed at the issues that you need to investigate. Before you can dig deep into SQL Server you will need a grasp of leverage dynamic management view, performance monitor, and extended events. These tools, along with activity monitor, provide the tool chest for the performance tuning.
  1. Creating and Monitoring Baselines
It can be extremely difficult to identify performance issues, when you don't know what a good processing level was before the performance issue. That is the key to capturing baselines, you need to establish a record of good, or normal, to compare against in the future. In this section, we'll review key information to collect and how to aggregate that information over time. We'll also review tools provided by Microsoft that can aid in maintaining performance.

    Day 2

  1. Inside the Query Optimizer
Before leveraging the waits and queues methodology, it is important to understand some of the basics on how SQL Server operates. This section will focus on how SQL Server processes queries and explain how the basic components operate and can be leveraged in performance tuning.
  1. Reading and Understanding Execution Plans
One of the core skills required for performance tuning is the ability to read and understand how SQL Server executes a query. In this session, we'll examine how to read execution plans, going from both right-to-left and left-to-right. By the end of this section, you will be able to read execution plans and understand where and when performance problems are occurring.
  1. SQL Server Data and Compression Internals
As a DBA we learn backwards. Most of the time you get a DBA job and you have Databases, that have tables, and in those tables you have data. Nobody tells you that we have records, stored on Pages, grouped in Extents, assigned by Allocation Bitmaps, with IAM Pages and Allocation Units that span Partitions and Filegroups. Today is your lucky day, we'll start at the bottom and build our way up. We'll cover byte swapping, bitmaps, and dive a little into decoding Hex and binary.

    Day 3

  1. Configuring SQL Server and Database for Performance
Before the first query is run, there are a number of steps that can, and should, be taken to best manage performance for SQL Server instances and databases. There are numerous little steps that can contribute to big performance gains. In this section, we'll review and demonstrate these performance options and provide you with the knowledge you need to design for performance.
  1. Transaction Log Performance Considerations
One of the easiest areas to bottleneck the performance of a SQL Server instance is in the configuration of the transaction logs. In this section, we'll look at the internals for transaction logs and some of the important considerations that need to be taken into account while working with SQL Server. You'll learn how transaction logs work and their potential impact on performance.
  1. CPU Internals and Performance Problems
When it comes to coordinating working, making requests, and performing operations, the CPU is the heart of all activity. It is the thinking portion of SQL Server hardware architecture and it is critical that sufficient resources are provides to SQL Server. In this section, we'll review the basics of CPU design and how these architectural differences can have an impact on performance.
  1. Memory Internals and Performance Problems
SQL Server is well known for its dependency on memory. In this section, we'll provide a walk-through on how SQL Server leverages memory and how to configure memory to optimize performance from your SQL Server environment.
  1. Storage Internals and Performance Problems
One of the key areas that contribute to performance issues is SQL Servers interaction with the underlying storage system. In this section, we'll review the available storage options and the pros and cons for each option. We'll review RAID configurations and how you can examine your workload to optimize the subsystem for your needs. In the second half of the segment, we'll tie storage into the waits and queues methodology.

    Day 4

  1. Network Related Performance Problems

Networking is often the forgotten child of performance tuning. Often times, networking related issues aren't even related to networking. In this section, we'll investigate how to identify network related issues and determine if they are actually related to other issues. Throughout this section, we'll provide an understanding of why you should pay attention to, but not overly focus in the network.
  1. Locking, Blocking, Latches and Spin Locks
Even with a performance tuning methodology in use, there are other performance related issues that you will need to look at from time to time. Some of these, such as locking issues, will appear as wait stats, while others, such as deadlocks, won't be quite as obvious.
  1. Indexing Internals, Design and Management
The key to any good database is data. The key to good performance within that database is indexes. With indexing, the primary goal is to provide applications with the most direct route from their request to the data available. This section will provide a framework for ensuring the proper indexes are always in place.

    Day 5

  1. Preventing T-SQL Performance Issues
No matter what you do, eventually, you will be sitting in front of your database with the need to either write or re-write some T-SQL. In this section, we'll review some patterns and practices for writing T-SQL. Followed by a good laugh as we review some anti-patterns that many of us have encountered before and review how to rewrite these queries to improve performance.
  1. Advanced Performance Tools
As we all progress and advance our performance tuning skills, there will be opportunities and situations where other tools will be useful. In this session, we'll review tools that you can use to analyze a SQL Server that doesn't have baselines or monitoring tools configured.


No comments:

Post a Comment