|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/server-performance-and-activity-monitoring/
课程评论：没有评论
**课程名称：** 服务器性能与活动监控 **课程概述：** 本课程旨在教授如何有效监控服务器性能，特别是针对Microsoft SQL Server数据库。通过定期快照和持续数据收集，学员可以识别性能瓶颈、追踪性能趋势，并利用Microsoft SQL Server和Windows操作系统提供的工具来诊断和解决问题。 **核心内容：** * **数据库监控的重要性：** 理解监控对于评估服务器性能、隔离问题进程以及追踪性能变化趋势至关重要。 * **Microsoft SQL Server 简介：** * SQL Server 作为一款关系型数据库管理系统，其核心功能是存储和检索数据。 * **Database Engine：** 作为SQL Server的核心组件，负责处理查询（关系引擎）和管理数据库文件、页面、索引等（存储引擎）。它还负责创建和执行存储过程、视图和触发器等数据库对象。 * **SQL Server 版本：** * **Developer Edition：** 免费提供，适用于数据库开发和测试。 * **Express Edition：** 免费提供，适用于小型数据库，磁盘存储容量限制为10GB。 * **Enterprise Edition：** 适用于大型和关键任务应用，包含所有SQL Server的特性。 * **Standard Edition：** 包含Enterprise Edition的部分特性，但在处理器核心和内存方面存在限制。 **学习目标：** 通过本课程的学习，学员将能够： * 掌握监控服务器性能的基本原理和方法。 * 熟悉Microsoft SQL Server的架构和核心组件。 * 了解不同SQL Server版本的特性和适用场景。 * 利用自带工具对SQL Server进行性能监控和分析。
The goal of monitoring databases is to assess how a server is performing. Effective monitoring involves taking periodic snapshots of current performance to isolate processes that are causing problems, and gathering data continuously over time to track performance trends. Microsoft SQL Server and the Microsoft Windows operating system provide utilities that let you view the current condition of the database and to track performance as conditions change.Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications-which may run either on the same computer or on another computer across a network.The core component of the SQL Server is the Database Engine. The Database Engine consists of a relational engine that processes queries and a storage engine that manages database files, pages, pages, index, etc. The database objects such as stored procedures, views, and triggers are also created and executed by the Database Engine.SQL Server has four primary editions that have different bundled services and tools. Two editions are available free of charge:SQL Server Developer edition for use in database development and testing.SQL Server Expression for small databases with the size up to 10 GB of disk storage capacity.For larger and more critical applications, SQL Server offers the Enterprise edition that includes all SQL server's features.SQL Server Standard Edition has partial feature sets of the Enterprise Edition and limits on the Server regarding the numbers of processor core and memory that can be configured.
