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!!!
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.
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.
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.
A little information about your authors.
The background of your authors is important.
Here's a short Bio on Ryan and Mike
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:
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.
This is where you'll download all the content for the course.
Let's wrap up what we've learned in this first section.
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.
These two tools are invaluable for learning how SQL Server works.
I use them in almost all of my courses.
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.
Let's learn a few ways to craft a highly functional script library.
Let's review what we've covered in Section 2.
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.
Capturing the specifics of the big three is the core of what we will do to tune our RDS insances.
Often we will need to capture wait stats for a very specific period.
This script will help us do just that.
Let's learn how to capture our wait stats during a specific period of time.
Let's wrap up what we've learned in Section 3.
We need to know what latch contention is before we can erradicate it.
Every production instance should have 4 tempdb data files.
This is how we set that up with our on premise databases.
We can't add files to tempdb in RDS so we are going to have to get our hands dirty.
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.
There are a few caveats to cleaning up our unused indexes.
Let's learn what they are in this lesson.
Fixing cache bloat is very easy but first let's learn what the caches are and what's often the bloater.
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.
We don't like growth but we can't stand incremental growth.
Let's learn what we can do about it in lecture 26.
This is often a hot button issue but for RDS we only have a few real options.
Let's learn what those are.
This goes hand in hand with our MAXDOP setting.
Let's bump it up everywhere.
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.
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
If you don't give the optimizer what it needs you'll pay the price.
Let's learn what index stats are.
Let's create a job to keep our statistics as updated as we can.
Reorgs are online and have gotten a lot cleaner in the latest versions. (2014)
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.
Here's a checklist of items covered in the course we should analyze then apply to our instances.
It's a word document.
Let's wrap up what we've learned in this section.
Congratulations and thank you!!!!
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 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).
Born in Ohio, raised and educated in Pennsylvania, I currently reside in Atlanta with my wife and two children.
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!