Performance Tuning SQL Server On RDS

Performance Tuning SQL Server On RDS

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!!!

A Real World Guide To Tuning Your RDS Instances

Url: View Details

What you will 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?

Rating: 3.9

Level: Intermediate Level

Duration: 1.5 hours

Instructor: Mike West