Ed Watson and I have been presenting a tag team performance tuning session for over a year now at local SQLSaturdays. We've had the pleasure of presenting the subject in multiple formats from 1 hour (rapid fire taste) to 8 hours as a precon session.
You probably already know who I am if you're reading my blog, in short I am a Linchpin People teammate and independent consultant with almost 20 years of SQL Server experience. My forte is performance tuning for large enterprise corporations with serious performance issues.
Ed Watson is a Microsoft MVP, and is a consultant in his day job. Ed has more than 15 years in IT, and has been a senior Production DBA for many years... you probably know him best as @SQLGator and can find him blogging at the SQLSwampland... yes he's a Florida Gator... don't hold it against him (I try not to).
September 25th, 2015, Ed Watson (b|t) and I will be presenting the session, "Getting the New DBA Up to Speed with Performance Tuning" as a full 8 hours class.
This session is for those guys or gals wanting to become a DBA, are an "accidental DBA" or a DBA with a little experience who wants to gain some add knowledge to their performance tuning playbook.
In this session we'll start at the beginning of the process of building the foundation following best practices for a highly tuned or tune-able environment. We will cover how to configure the OS and database server to best take advantage of features built in to the OS and SQL Server for peak performance. We'll dig into some of the database server configurations that effect performance such as "Optimize for Adhoc Workloads", MAXDOP and "Cost Threshold for Parallelism".
We'll talk about TempDb optimizations, and why they make a difference and how to find the correct number of data files.
We'll cover benchmark basics and how to see that your database performance is suffering compared to historical expectations.
Once you have the foundation needed to build a stable environment we'll look at some of the top performance issues and how to identify them when you've had a complaint about performance. Using some of the free tools that come with SQL Server, such as extended events, we'll teach you how to trap what is causing the slowness in the database for many issues encountered by a DBA.
We'll spend more than an hour going over execution plans from beginning concepts to some advanced topics (don't worry, we'll make sure we don't go too far). We'll make sure you know where to get more information from some of our performance tuning heros!
But wait, there's more... we'll share with you some of our favorite scripts that we've collected over time that will give you a little bit of an edge next time someone calls and says, "everything is slow", help!!
All of this for an extremely low price of $150... that is the sum total of $18.75 per hour!!
We can't wait to see you at "Getting the New DBA Up to Speed with Performance Tuning"
SQL Server Innovators Guild (ssig)
Friday, September 25, 2015 from 8:30 AM to 5:00 PM (EDT)