Performance Tuning SQL Server On RDS
4.1 (11 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.
175 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Performance Tuning SQL Server On RDS to your Wishlist.

Add to Wishlist

Performance Tuning SQL Server On RDS

A Real World Guide To Tuning Your RDS Instances
4.1 (11 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.
175 students enrolled
Last updated 9/2015
English
Current price: $10 Original price: $20 Discount: 50% off
4 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 2 mins on-demand audio
  • 14 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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?
View Curriculum
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.
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!!!

Who 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
37 Lectures
01:36:31
+
Introduction and Preparation
7 Lectures 09:42

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.

Preview 01:28

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.

Is This Course For You?
02:01

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.

Student Expectations. What Should You Know Before Taking This Course.
00:55

A little information about your authors.

The background of your authors is important.

Here's a short Bio on Ryan and Mike

Your Instructors
01:20

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.

Preview 03:12

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


Download Course Content Here
00:06

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

Section 1 Summary
00:39

Section 1 Quiz
10 questions
+
Installation
5 Lectures 12:55

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.

Preview 01:57

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

I use them in almost all of my courses.

Preview 06:55

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.

Watching Transactions in The Cloud
02:16

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

Creating Our Script Library For RDS
01:21

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

Section 2 Summary
00:25

Section 2 Quiz
10 questions
+
Capturing Several Key Metrics
5 Lectures 14:34

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.

The Canned Metrics Built Into RDS
00:37

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

Capturing IO Metrics Over a Period Of Time on RDS
05:10

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

This script will help us do just that.

Capture Wait Statistics During A Specified Period
03:45

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

Two Ways To View Our Wait Statistics
04:09

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

Section 3 Summary
00:53

Section 3 Quiz
8 questions
+
Performance Tuning.
19 Lectures 57:53

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

What is latch contention on tempdb
00:48

Every production instance should have 4 tempdb data files.

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

Avoiding Tempdb Latch Contention With On Premise Databases
05:49

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

Avoiding Tempdb Latch Contention With RDS Databases
07:52

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.

Why Too Many Indexes Are Bad. It's Not About Space
01:11

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

Let's learn what they are in this lesson.

Removing Our Unused Indexes
05:17

Adding High Impact Indexes is much Harder and More Important than anything else
01:33

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

How Can We Tell If Our Cache Is Bloated?
02:20

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.

Changing Optimize For Adhoc Workloads on RDS
02:58

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

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

Fixing The Incremental Growth Where We Can
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.

Setting MAXDOP On An RDS Instance
05:15

This goes hand in hand with our MAXDOP setting.

Let's bump it up everywhere.

Cost Of Threshold For Parallelism on RDS
03:39

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.

Grow Our Files After Core Hours
01:18

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

Why I don't like Online Rebuilds.
00:24

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

Let's learn what index stats are.

What Are Index Statistics?
01:17

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

Create A Job To Update Index Statistics
04:58

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

To Rebuild or To Reorganize... That is the Question
04:01

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.

Vertically Scaling An RDS Instance
01:57

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

It's a word document.

Checklist To Track Our Changes
00:12

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

Section 4 Summary
01:48

Section 4 Quiz
15 questions
+
Conclusion
1 Lecture 01:05

Congratulations and thank you!!!!

Section 5 Summary
01:05
About the Instructor
Mike West
4.2 Average rating
2,202 Reviews
35,651 Students
37 Courses
SQL Server and Machine Learning 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.

Ryan Kroonenburg
4.5 Average rating
49,786 Reviews
163,323 Students
15 Courses
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!