Performance Tuning SQL Server On RDS

A Real World Guide To Tuning Your RDS Instances
4.3 (3 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
103 students enrolled
$20
Take This Course
  • Lectures 37
  • Contents Video: 1.5 hours
    Other: 15 mins
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 9/2015 English

Course Description

This course focuses on making SQL Servers on RDS more performant.

RDS is an acronym that stands for Relational Database Service. It's part of Amazon's CLOUD offering called AWS, another acronym which stand for Amazon Web Services.

Performance tuning can be difficult enough with an on premise SQL Server. RDS complicates things further be adding another level of complexity. That complexity is that almost all of our server level permissions and access have been removed.

In this course WE will overcome these limitations by tailoring OUR performance tuning approach specifically to RDS. Our SOLE focus in this course will be strictly on RDS.

SQL Server is like a high performance sports car. Anyone can drive it but put it in the hands of a skilled performance tuner and you've just gone from average to incredible.

This course will give YOU the foundation to become a skilled PERFORMANCE TUNER on RDS. The cloud has some nuances but SQL Server still relies on CPU, Memory and IO and that means WE will simply have to alter our methodology slightly.

Once thought of as an art, performance tuning is nothing more than a series of processes that seek to accomplish TWO basic goals.

The FIRST one is to reduce the response time for a given transaction or set of transactions.

The SECOND one is reduce resource consumption. On the surface this sounds simple but nothing could be further from the truth.

This course WILL provide YOU with the foundation necessary to ensure data can be saved and retrieved so YOUR RDS databases will have an organic flow of transactions.

ENROLL now. Let's get started!!!

What are the requirements?

  • You will need to have SQL Server 2012 or 2014 installed. It can be an express version.
  • You'll need an active AWS account and understand the basics of AWS and RDS.
  • If you're not familiar with SQL Server fundamentals then this course may not be for you. I do appreciate and understand your enthusiasm and promise this course will be here when you're ready.

What am I going to get from this course?

  • By the end of this course you will have a systematic process approach and all the necessary tools needed to begin your journey as a SQL Server performance tuner.
  • In this course we will define our performance tuning objectives before we dive head first into tuning. What is our end goal?

What is the target audience?

  • This is a more advanced course. The student should have a solid foundation in SQL Server and AWS
  • This course is not a beginner’s course. Most of the students will be junior to mid-level SQL Server resources.
  • The student should have SQL Server installed locally and have an active AWS account.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction and Preparation
01:28

RDS is Amazon's relational database system. This course was specifically designed to optimize the performance of SQL Server databases on the RDS platform.

Our goal is the same. We want to ensure SQL Server is configured to run as optimimally as it can in our cloud environment.

02:01

This is my most niche course. I want to make sure this course is right for you.

Are you DBA looking to tune your SQL Servers on RDS?

If you are then this course is for you.

If you are looking to learn how to be a senior level SQL Server cloud resources then this course is for you.

Article

Because this is an advanced course my expectations for the knowledge students need to bring to this course is higher than most of my other courses.

The content is not difficult but you'll need some AWS basics and strong fundamentals to get the most out of this course.

Article

A little information about your authors.

The background of your authors is important.

Here's a short Bio on Ryan and Mike

03:12

What is the course about? Performance tuning is a complicated subject but in this course we will break down the basics.

Our two main goals will be:

  • Reduce critical resource consumption.
  • Increase transaction speed.

We use the same basic approach to tuning an RDS instance with one difference.

Our access to the OS is very limited to we will have to be a little more creative in our tuning approach.

Article

This is where you'll download all the content for the course.


Article

Let's wrap up what we've learned in this first section.

Section 1 Quiz
10 questions
Section 2: Installation
01:57

Le's create a separate script library because certain scripts will work on RDS that won't run on our on premise boxes and vice versa.

Having them separated will make our lives easier.

06:55

These two tools are invaluable for learning how SQL Server works.

I use them in almost all of my courses.

02:16

No matter where SQL Server resides, the core engine is the same.

The job of SQL Server is to process transactions and store information on those transactions somewhere.

Article

Let's learn a few ways to craft a highly functional script library.

Article

Let's review what we've covered in Section 2.

Section 2 Quiz
10 questions
Section 3: Capturing Several Key Metrics
Article

We don't have access to performance monitor on our RDS instances but Amazon does provide a two week view of our most critical metrics.

Let's learn how to view that data.

05:10

Capturing the specifics of the big three is the core of what we will do to tune our RDS insances.

03:45

Often we will need to capture wait stats for a very specific period.

This script will help us do just that.

04:09

Let's learn how to capture our wait stats during a specific period of time.

Article

Let's wrap up what we've learned in Section 3.

Section 3 Quiz
8 questions
Section 4: Performance Tuning.
Article

We need to know what latch contention is before we can erradicate it.

05:49

Every production instance should have 4 tempdb data files.

This is how we set that up with our on premise databases.

07:52

We can't add files to tempdb in RDS so we are going to have to get our hands dirty.

01:11

Almost every single instances I've looked at in the past decade had indexes that were hurting performance.

It's time to clean them up everywhere.

05:17

There are a few caveats to cleaning up our unused indexes.

Let's learn what they are in this lesson.

Adding High Impact Indexes is much Harder and More Important than anything else
Article
02:20

Fixing cache bloat is very easy but first let's learn what the caches are and what's often the bloater.

02:58

This is an easy button fix with our on premise instances and it's not much harder on RDS.

Let's learn how to flip this switch.

05:15

We don't like growth but we can't stand incremental growth.

Let's learn what we can do about it in lecture 26.

05:15

This is often a hot button issue but for RDS we only have a few real options.

Let's learn what those are.

03:39

This goes hand in hand with our MAXDOP setting.

Let's bump it up everywhere.

01:18

If we can we should be growing all of our files after hours so we don't grow during core hours.

Let's learn how to do this.

It's the same with RDS and on premise.

Article

I like offline rebuilds for the cleanest indexes but online reorgs have begun to win me over.

In this lecture I'll tell you why I loathe online rebuilds

01:17

If you don't give the optimizer what it needs you'll pay the price.

Let's learn what index stats are.

04:58

Let's create a job to keep our statistics as updated as we can.

04:01

Reorgs are online and have gotten a lot cleaner in the latest versions. (2014)

01:57

Easily one of the top features in RDS.

I can add memory and cpu to my RDS instance with the click of a button.

Let's learn how.

Article

Here's a checklist of items covered in the course we should analyze then apply to our instances.

It's a word document.

Article

Let's wrap up what we've learned in this section.

Section 4 Quiz
15 questions
Section 5: Conclusion
Article

Congratulations and thank you!!!!

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Mike West, SQL Server Evangelist

I've been a production SQL Server DBA most of my career.

I've worked with databases for over two decades. I've worked for or consulted with over 50 different companies as a full time employee or consultant. Fortune 500 as well as several small to mid-size companies. Some include: Georgia Pacific, SunTrust, Reed Construction Data, Building Systems Design, NetCertainty, The Home Shopping Network, SwingVote, Atlanta Gas and Light and Northrup Grumman.

Experience, education and passion

I learn something almost every day. I work with insanely smart people. I'm a voracious learner of all things SQL Server and I'm passionate about sharing what I've learned. My area of concentration is performance tuning. SQL Server is like an exotic sports car, it will run just fine in anyone's hands but put it in the hands of skilled tuner and it will perform like a race car.

Certifications

Certifications are like college degrees, they are a great starting points to begin learning. I'm a Microsoft Certified Database Administrator (MCDBA), Microsoft Certified System Engineer (MCSE) and Microsoft Certified Trainer (MCT).

Personal

Born in Ohio, raised and educated in Pennsylvania, I currently reside in Atlanta with my wife and two children.

Instructor Biography

Ryan Kroonenburg, Solutions Architect

I am the founder of A Cloud Guru and an Amazon Web Services community hero. I hold every associate certification and I am a certified AWS Solutions Architect Professional. I am ex-Rackspace, ex-Sungard & ex-Smart421. I have been working in the Cloud space since it's very inception.

I am not just another I.T. trainer. I teach Cloud because I know it. Inside and out. I've worked as a systems administrator, developer, solutions architect & managing director/general manager for some of the biggest companies in cloud. My courses are not just some other IT training course, delivered by some IT trainer. My background is very hands on. I live eat and breath cloud. I will teach you everything that I know. If you want some boring, high level and theoretical cloud training platform, then my courses are not for you! You will love my courses because of my explain it like I'm 5 approach.

I have 17 years experience in IT in total and I am fluent across both Windows and Linux platforms. My courses are all cloud based and will be aimed to accommodate both absolute beginners, as well professionals. I always start with the basics and by the end of my courses you will be proficient as a Cloud Guru. Please add me on Linkedin or follow me on Twitter!

Get ready to become A Cloud Guru!

Ready to start learning?
Take This Course