Course Information
Course Overview
A Real World Guide To Tuning Your RDS Instances
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!!!
Course Content
- 5 section(s)
- 37 lecture(s)
- Section 1 Introduction and Preparation
- Section 2 Installation
- Section 3 Capturing Several Key Metrics
- Section 4 Performance Tuning.
- Section 5 Conclusion
What You’ll 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?
Skills covered in this course
Reviews
-
VVamsi Krishna
Very specific to RDS AWS Performance tuning also need on-prem performance tuning skills to apply this course. Outdated , no mention of Performance insights. ....WASTE OF TIME AND MONEY
-
LLogan Galler
the course is outdated and the some of tools are not available, not to mention scripts missing and it would be nice to have the scripts for the database used in samples
-
DDavid Akin
Information is a bit out dated as CodePlex not longer exists and the sp_whoisactive returns no data. there is something missing.
-
DDebasish Panda
The course is too basic and small. There is many thing to be described. Only covers few.