|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/building-an-automated-sql-server-performance-tuning-engine/
课程评论：没有评论
**课程名称：** 构建自动化 SQL Server 性能调优引擎 **课程概述：** 本课程旨在教授学员如何构建一个全自动化的 SQL Server 实例性能调优应用程序。作者开发的名为 "SQL Black Box" 的软件已在生产环境中运行多年，有效减少了对人工性能调优的需求。 **核心内容：** * **自动化应用构建：** 学习如何使用 C# 和 Transact-SQL 构建自动化 SQL Server 性能调优应用程序。 * **模块化设计：** 课程将讲解构成应用程序的各个独立工作单元（模块），例如移除重复数据和添加高影响力索引。 * **实例级调优：** 重点在于对 SQL Server 实例进行调优，因为关键资源在实例级别共享，而不是单个数据库。 * **适用性：** 学员能够将构建的应用程序部署到任何 SQL Server 实例，减轻日常管理负担。 * **灵活性：** 无论经验水平如何，学员都可以从中受益。高级用户可以选择实现特定的调优模块，而初学者则可以通过修改少量代码并利用任务计划程序实现自动化。 **目标学员：** SQL Server DBA 以及希望自动化和简化性能调优工作的系统管理员。 **限制：** 课程代码不得转售。
Recent Reviews: "Mike has given a great template that will allow DBAs to ease their admin tasks. Really well done." - Doug Alderson "This is a great tool to help DBAs and non- database system administrator for performance fine tuning" - Bernard Bernard Welcome to Building an Automated SQL Server Performance Tuning Engine. In this course, we are going to build a completely automated application for tuning a SQL Server instance. The application has been running on live production instances for several years. These SQL Servers have needed no performance tuning attention since the tool was installed. I've created the software and named it SQL Black Box. I choose the name because for most in the organization the inner workings of the tool will be a black box. The software in the course will be written in C# and the SQL Server code will obviously be transact-sql. This is not a step by step on how I authored the code. This course assembles the sundry components that make up the application. You'll be able to take the application and install it on any SQL Server you want. You won't be able to resale any portion of the code but that's the only restriction. Regardless of your skill level this application will ease your administrative burden. Advanced students will be able to choose what modules they want to implement. I use the term module within the software to denote individual unit of work. For example, there will be a module that removes exact duplicates and there will be a module that adds high impact indexes to the instance. Please note I used the word instance and not databases. We don't tune databases; we tune the instance they are on because all the critical resources are shared at that level. Those students newer to SQL Server will be able to change a couple of lines of code, build the modules and then use task scheduler to automated their schedules. Thank you for your interest in Building an Automated SQL Server Performance Tuning Engine and we will see you in the course.
