|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/performance-tuning-sql-server-on-rds/
课程评论：没有评论
课程名称：在RDS上进行SQL Server性能调优 课程概述：本课程专注于提升RDS（关系数据库服务）上的SQL Server性能。RDS是亚马逊云服务（AWS）的一部分，进行性能调优在本地SQL Server上已经颇具挑战，而RDS则进一步增加了复杂性，因为我们几乎失去了所有服务器级别的权限和访问权限。本课程将通过针对RDS量身定制的性能调优方法来克服这些限制。我们将重点关注RDS环境。 SQL Server如同一辆高性能跑车，任何人都能驾驶，但如果交给熟练的性能调优师，则能从普通水平提升到惊人水平。课程将为您提供在RDS上成为熟练性能调优师所需的基础知识。尽管云环境有其独特性，SQL Server依然依赖于CPU、内存和I/O，这意味着我们会稍微调整我们的调优方法。 性能调优曾被认为是一门艺术，其实只是一系列旨在实现两个基本目标的过程：第一，减少特定事务或事务集的响应时间；第二，减少资源消耗。表面上看似简单，但实际远比这复杂。本课程将为您提供必要的基础，确保数据可以顺利储存和检索，使您的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!!!
