|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-performance-tuning-practically-in-sql-server/
课程评论：没有评论
**Coursera 课程总结：SQL Server 性能调优实战** 本课程专为所有希望优化 SQL Server 实例和数据库性能的学生设计，包括开发人员、SQL DBA、IT 人员甚至网络管理员。 **课程核心内容：** 课程将深入讲解 SQL Server 性能调优的各个方面，涵盖以下主题： * **监控与诊断工具：** * DMV (动态管理视图) * Profiler (性能监视器) * DBCC (数据库一致性检查命令) * Execution Plan (执行计划) * Database Engine Tuning Advisor (数据库引擎优化顾问) * Activity Monitor (活动监视器) * PerfMon (性能监视器) * Event Viewer (事件查看器) * Task Manager (任务管理器) * **性能瓶颈与优化：** * Indexes (索引) * Statistics (统计信息) * Waits (等待类型) * CPU, IO and Memory (CPU、IO 和内存) * Long running queries (长查询) * Locks & Blockings and Deadlocks (锁、阻塞和死锁) * Temp DB Issues (TempDB 相关问题) **课程目标：** 完成本课程后，学员将掌握使 SQL Server 运行更优化的方法，并获得以下方面的深入知识： * **深入理解性能调优原理：** 课程将延续“由上而下”的调优方法，不仅教授“如何做”，更会深入讲解“为什么这样做”。 * **实操性强的调优技巧：** 课程侧重于“按钮和旋钮”式的操作，强调易于实施的调优项，避免过于深入的技术细节。 * **解决实际性能问题：** 学员将学会如何诊断和解决 CPU、IO、内存、锁、阻塞、死锁以及 TempDB 等方面的性能瓶颈。 * **提升性能调优技能：** 课程旨在帮助学员成为一名熟练的性能调优专家，理解性能调优背后的逻辑和原理。 **课程特点：** 尽管名称中包含“高级”字样，但本课程内容并不复杂，易于在实际工作中应用。课程将详细解释实施调优建议的步骤，即使是资深技术人员也可能从中获得新的见解。学员可以根据自己的情况决定是否采纳某些调优建议，因为某些概念在技术社区中可能存在争议。“性能调优”不再是一门神秘的艺术，而是可以通过学习掌握的实用技能。 **立即报名，开启您的性能调优之旅！**
As part of this course you are learning below Topics Here are the following topics related to performance tuning:-DMV's-Store Procedures-DBCC-Profiler-Execution Plan-Database Engine Tuning Advisor-Activity Monitor-PerfMon-EventViewer-Task Manager-Indexes-Statistics- Waits- CPU, IO and Memory and long running queries- Locks & Blockings and Deadlocks-Temp DB Issues COURSE INTRODUCTIONThis course is designed for any student that is interested in learning about how to fine tune their SQL Server and databases. Also, developers, SQL DBAs, IT staff and Network AdministrationAt the end of this course, the student will have extensive knowledge in the following areas:This course focuses on making SQL Server perform more optimally.In my first course we laid the groundwork by tuning OUR instances with a top down approach.WE will continue on that path with this course.Even though the course has the word "Advanced" in it, there's NOTHING COMPLICATED about taking what's in the course and applying it in the real word.It's "advanced" in that I'll take more time explaining how to implement these recommendations.The course is still very much a "buttons and Knobs" course. This simply means WE won't dive too deeply into the minutia. We are still going to focus on items that are easily implemented. Some features will have a level of contention associated with them in the SQL Server community. It will be up to you decide to implement or not.Additionally, some of the concepts may be new to even more senior level resources so I want to make sure I'll cover the why of the topic as well as the how.This course will give YOU deeper insight into what it takes to become a skilled PERFORMANCE TUNER. Once thought of as an art, performance tuning is nothing Take the next step on YOUR performance tuning journey and SIGN UP now.
