Udemy

Performance Tuning SQL Server On RDS

Enroll Now
  • 488 Students
  • Updated 9/2015
3.6
(50 Ratings)
CTgoodjobs selects quality courses to enhance professionals' competitiveness. By purchasing courses through links on our site, we may receive an affiliate commission.

Course Information

Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
1 Hour(s) 36 Minute(s)
Language
English
Taught by
Mike West
Rating
3.6
(50 Ratings)

Course Overview

Performance Tuning SQL Server On RDS

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?


Reviews

  • V
    Vamsi Krishna
    1.0

    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

  • L
    Logan Galler
    1.0

    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

  • D
    David Akin
    3.0

    Information is a bit out dated as CodePlex not longer exists and the sp_whoisactive returns no data. there is something missing.

  • D
    Debasish Panda
    2.0

    The course is too basic and small. There is many thing to be described. Only covers few.

Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed