“监视 Always On 可用性组的工具”"Tools to monitor Always On availability groups"

适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) 适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions)

若要监视 AlwaysOn 可用性组的属性和状态,可以使用以下工具。To monitor the properties and state of an Always On availability group you can use the following tools.

工具Tool 简要说明Brief Description 链接Links
SQL Server 的系统中心监视包System Center Monitoring pack for SQL Server 对于 IT 管理员,建议使用 SQL Server (SQLMP) 的监视包这一解决方案来监视可用性组、可用性副本和可用性数据库。The Monitoring pack for SQL Server (SQLMP) is the recommended solution for monitoring availability groups, availability replica and availability databases for IT administrators. Always On 可用性组Always On availability groups 尤为相关的监视功能包括:Monitoring features that are particularly relevance to Always On 可用性组Always On availability groups include the following:

可自动发现数百台计算机中的可用性组、可用性副本和可用性数据库。Automatic discoverability of availability groups, availability replicas, and availability database from among hundreds of computers. 这使您能够轻松地跟踪 Always On 可用性组Always On availability groups 清单。This enables you to easily keep track of your Always On 可用性组Always On availability groups inventory.

功能完善的 System Center Operations Manager (SCOM) 报警和票证。Fully capable System Center Operations Manager (SCOM) alerting and ticketing. 这些功能提供了详细的知识,使您可以更快地解决问题。These features provide detailed knowledge that enables faster resolution to a problem.

使用基于策略的管理 (PBM) 对 AlwaysOn 运行状况监视进行自定义扩展。A custom extension to Always On Health monitoring using Policy Based management (PBM).

从可用性数据库到可用性副本累积运行状况信息。Health roll ups from availability databases to availability replicas.

用于从 System Center Operations Manager 控制台中管理 Always On 可用性组Always On availability groups 的自定义任务。Custom tasks that manage Always On 可用性组Always On availability groups from the System Center Operations Manager console.
若要下载监视包 (SQLServerMP.msi) 和 用于 System Center Operations Manager 的 SQL Server 管理包指南 (SQLServerMPGuide.doc),请参阅:To download the monitoring pack (SQLServerMP.msi) and SQL Server Management Pack Guide for System Center Operations Manager (SQLServerMPGuide.doc), see:

SQL Server 的系统中心监视包System Center Monitoring pack for SQL Server
Transact-SQLTransact-SQL Always On 可用性组Always On availability groups 目录和动态管理视图提供了有关可用性组及其副本、数据库、侦听器和 WSFC 群集环境的大量信息。catalog and dynamic management views provide a wealth of information about your availability groups and their replicas, databases, listeners, and WSFC cluster environment. 监视可用性组 (Transact-SQL)Monitor Availability Groups (Transact-SQL)
SQL Server Management StudioSQL Server Management Studio “对象资源管理器详细信息” 窗格显示有关您连接到的 SQL ServerSQL Server 实例所承载的可用性组的基本信息。The Object Explorer Details pane displays basic information about the availability groups hosted on the instance of SQL ServerSQL Server to which you are connected.

** 提示 ** 使用此窗格可以选择多个可用性组、副本或数据库,并能对选定对象执行常规管理任务;例如,从可用性组中删除多个可用性副本或数据库。** Tip ** Use this pane to select multiple availability groups, replicas, or databases and to perform routine administrative tasks on the selected objects; for example, removing multiple availability replicas or databases from an availability group.
使用对象资源管理器详细信息监视可用性组 (SQL Server Management Studio)Use the Object Explorer Details to Monitor Availability Groups (SQL Server Management Studio)
SQL Server Management StudioSQL Server Management Studio “属性” 对话框使您能够查看可用性组、副本或侦听器的属性,并在某些情况下可更改这些属性的值。Properties dialog boxes enable you to view the properties of availability groups, replicas, or listeners and, in some cases, to change their values. - 查看可用性组属性 (SQL Server)- View Availability Group Properties (SQL Server)
- 查看可用性副本属性 (SQL Server)- View Availability Replica Properties (SQL Server)
- 查看可用性组侦听程序属性 (SQL Server)- View Availability Group Listener Properties (SQL Server)
系统监视器System Monitor SQLServer:Availability Replica 性能对象包含性能计数器,可报告可用性副本的相关信息。The SQLServer:Availability Replica performance object contains performance counters that report information about availability replicas. SQL Server,可用性副本SQL Server, Availability Replica
系统监视器System Monitor SQLServer:Database Replica 性能对象包含性能计数器,可报告给定次要副本上的辅助数据库的相关信息。The SQLServer:Database Replica performance object contains performance counters that report information about the secondary databases on a given secondary replica.

SQL Server 中的 SQLServer:Databases 对象包含用于监视事务日志活动(但不仅限于此)的性能计数器。The SQLServer:Databases object in SQL Server contains performance counters that monitor transaction log activities, among other things. 下列计数器特别适用于监视可用性数据库上的事务日志活动: 日志刷新写入时间(秒)日志刷新次数/秒日志池缓存未命中数/秒日志池磁盘读取次数/秒日志池请求数/秒The following counters are particularly relevant for monitoring transaction-log activity on availability databases: Log Flush Write Time (ms), Log Flushes/sec, Log Pool Cache Misses/sec, Log Pool Disk Reads/sec, and Log Pool Requests/sec.
SQL Server,数据库副本 ;和 SQL Server,数据库对象SQL Server, Database Replica and SQL Server, Databases Object

另请参阅See Also

AlwaysOn 可用性组目录视图 (Transact-SQL) Always On Availability Groups Catalog Views (Transact-SQL)
AlwaysOn 可用性组动态管理视图和函数 (Transact-SQL) Always On Availability Groups Dynamic Management Views and Functions (Transact-SQL)
针对可用性组的自动故障转移的灵活的故障转移策略 (SQL Server) Flexible Failover Policy for Automatic Failover of an Availability Group (SQL Server)
AlwaysOn 可用性组概述 (SQL Server) Overview of Always On Availability Groups (SQL Server)
自动页修复(可用性组:数据库镜像) Automatic Page Repair (Availability Groups: Database Mirroring)
使用 AlwaysOn 面板 (SQL Server Management Studio)Use the Always On Dashboard (SQL Server Management Studio)