Pre-Con: Performance Tuning Training in Spartanburg, SC for #SQLSat431

On Friday, September 25th, 2015, Mike Lawell (b|t) and I will be giving our “Getting the New DBA Up to Speed with Performance Tuning” pre-con training for the inaugural SQL Saturday Spartanburg.  We are extremely excited to be presenting this training again this year after the tremendous feedback we received earlier in Nashville.  We have a passion for the SQL community and helping DBAs and developers to do their job better.  We want to help you too!  If you’ve never taken a pre-con before a SQL Saturday, it is a great way to get some high quality training at a low price and in your local area.  Register here today!
sqlsat431_web

In this session, we will take an in-depth look at performance tuning for the beginning DBA as well as the “Accidental DBA” in order to help prepare you for beginning to intermediate skills in tuning your real world queries. We will show you how to get started when you get the production support call stating that the database is slow. We will cover the basics of reading query execution plans as well as using dynamic management views in order to diagnose poor performance. We will also cover performance analysis tools and performance troubleshooting as well as some great demos to get you up and running tuning queries.

Prerequisites: Basic understanding of T-SQL and the SQL Server relational engine

Sections:

  • An overview of server configuration best practices will be discussed along with key tools that can be used to identify performance problems.
  • Several DMVs will be covered that can be used for performance data collection and diagnosis of performance issues. Third party free tools that use these DMVs will be demonstrated for the data collection.
  • Common performance issues will be discussed along with the methods that can be used to identify the issues and resolve.
  • The final section will look at the graphical Execution Plan basics and how to identify potential performance issues.

We are planning on a day filled with fun and adventure!  Let us help you become a better DBA!  Not a DBA?  No problem!  This is also an excellent training for developers who are writing queries in T-SQL!

Register here!

If you cannot make it to the pre-con, then make sure you check out our regular sessions on Saturday.  Register here!  Enjoy!

Advertisements

About SQLGator

Florida Gator and Microsoft Data Platform MVP, Star Wars fanatic and is there anything else...oh yeah PS4! I am a geek and SQL Server DBA who dabbles with VMWare, there are other technologies greater than these? Not so fast my friend! I also love to travel to new and exotic places.

Posted on September 9, 2015, in Performance Tuning, SQL Saturday, Training and tagged , , . Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: