|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-server-performance-tuning-part-2/
课程评论：没有评论
**课程摘要：SQL Server 性能调优（第二部分）** 本课程是为具备 SQL 管理知识、希望深入学习 SQL Server 性能调优的学生量身打造，是 SQL Server 性能调优系列课程的第二部。成功完成本课程后，学员将能够运用性能监视器、数据库调整顾问 (DTA)、动态管理视图 (DMV)、扩展事件 (Extended Events)、SQL Server Profiler 等多种工具和实用程序，诊断和解决索引调优、页面拆分、tempdb 数据库大小设置、存储过程重编译等一系列常见性能问题。通过本课程的学习，您将能够确保 SQL Server 实现最优运行，并为应对工作中遇到的更棘手性能挑战积累丰富的故障排除和问题解决能力。 **先修要求：** 具备 SQL Server 性能调优第一部分的知识。
This course is designed for any student who has knowledge of SQL Administration and wants to learn about SQL Server performance tuning their SQL servers. You must have the prerequisite SQL performance tuning part 1 course. This is the second part of SQL Server performance tuning course; at the end of this course the student will be able to resolve and troubleshoot issues related index tuning, page splitting, tempb database sizing, recompilation of stored procedures, and much more with the use of tools and utilities such the performance monitor, DTA, DMVs, extended events, profiler and other tools. This will allow you to have an optimum running SQL Server and an extensive knowledge of how to trouble shoot and resolve the more pressing issues you may face in your environment.
