暂时无法在支持网站上提交享有定期维护的产品表单。 如果您需要我们立即提供帮助，请与技术支持部门联系。 对于由此给您带来的不便，我们深表歉意。
获得即时帮助
完成注册
登录
请求定价
联系销售人员
您已选择一个产品捆绑包。 您能否选择单个产品以便我们更好地满足您的请求。 *
技术支持工程师目前正忙，无法回应您的消息。 如果需要即时服务，请通过我们的服务请求表提交请求。
以下文章可根据您的描述解决您的问题。
It collects SQL Server Availability Groups.
SQL Server.
Real-time
20
Online
60
Offline
300
Availability Group Name
Name of the availability group. This is a user-specified name that must be unique within the Windows Server Failover Cluster (WSFC) cluster.
Availability Group ID
Unique identifier (GUID) of the availability group.
Ag Resource ID
Unique ID of the availability group as a resource in the WSFC cluster.
Ag Databases Group ID
Unique WSFC databases Group ID of the availability group.
Primary Replica
Name of the server instance that is hosting the current primary replica.
NULL = Not the primary replica, or, unable to communicate with the WSFC failover cluster.
Primary Recovery Health
Indicates the recovery health of the primary replica, one of:
0 = In progress
1 = Online
NULL
Secondary Recovery Health
Indicates the recovery health of a secondary replica, one of:
Synchronization Health
One of:
0 = Not healthy
1 = Partially healthy
2 = Healthy
This metric summarizes the synchronization status of all replicas in the availability group:
• Healthy if all replicas are fully synchronized.
• Partially healthy if only some of the replicas are fully synchronized.
• Not healthy if no replica is fully synchronized.
Failure Condition Level
0 - No automatic failover or restart;
1 - Failover or restart on server down;
2 - Failover or restart on server unresponsive;
3 - Failover or restart on critical server errors;
4 - Failover or restart on moderate server errors;
5 - Failover or restart on any qualified failure conditions.
Health Check Timeout
Availability Group health check timeout in milliseconds.
Automated Backup Preference
At an availability group level, specify whether backups should or should not run on the primary replica.
The possible preferences for where backups should run are as follows:
0 - PRIMARY - Only on the primary replica - Backups should always occur on the primary replica.
1 - SECONDARY_ONLY - Performing backups on a secondary replica is preferable.
2 - SECONDARY - Performing backups on a secondary replica preferable, but performing backups on the primary replica is acceptable if no secondary replica is available for backup operations. This is the default behavior.
3 - NONE - No preference about whether backups are performed on the primary replica or on a secondary replica.
The collection shows drives or shares for backup locations.
3600
Member Name
The total free space of the backup media.
Error Message
It indicates that there has been an error, which trying to reach media for inspection.
Media Used Space
The total used space on the media.
Media Free Percentage
The percentage of free space out of the total size of the media.
Media Used Percentage
The percentage of the used space our of the total size of the media.
This collection retrieves the hierarchical tree of all sessions involved in the blocking process. The hierarchical tree is based on snapshots taken at a predefined interval.
Blocked
The total number of all blocked sessions.
Blocked by
The session that is currently blocking the selected session.
Blocked Time
Total wait time spent by all blocked sessions.
Command
The current or previous command executed.
CPU
The total amount of CPU consumed so far by the session. This metric can be useful when deciding which sessions to kill.
Database
The name of the database.
Host Name
The name of the client computer.
Lock Type
The type of the resource that is currently locked (Database, Table, Page, Row, Extent, and so on).
Locking
The unique session number for the session that either owns or requests the lock.
Login Time
The time that the session was created.
Mode
The kind of lock being applied to the resource (Shared, Exclusive, Update, IntentShared, IntenExclusive and so on).
OS User
Windows user name for a session that uses Windows Authentication.
Physical IO
The total amount of I/O operations carried out so far by the session. This metric can be useful when deciding which sessions to kill.
Program
The name of the application that the user is currently running (for example, Microsoft Access).
Request Status
Resource
The resource that is in conflict. This metric often identifies a database and table.
The data in the Resource column is reported directly from SQL Server and, for performance reasons, is not resolved to actual resource names during normal data collection.
SQL Text
Displays the SQL text of the session that is blocked and/or blocking.
SQL User
The SQL Server user login name for this session.
Status
The status of the session (Blocked, Blocking or both). For sessions at the head of the blocking chain (those that are not blocked), this metric also indicates if the session is Runnable or Sleeping.
Type
The type of the lock request that is waiting (for example: Database, Table, Page, Row, Key, and Extent).
Wait Time
Indicates how long this session has been waiting for the lock (measured in seconds). This shows 0 if the session is not waiting.
This collection provides a display of a hierarchical list of sessions, which sorts the blocked and blocking sessions in a logical order.
This collection is an on-demand collection, which has no pre-defined sampling intervals.
Blocked By SPID
Indicates which SPID (if any) holds locks on a resource on which this session is waiting.
The current or previous command executed. This information can be useful when deciding which sessions to kill.
The total amount of CPU consumed by the session so far. This information can be useful when deciding which sessions to kill.
The name of the Client computer.
Physical I/O
The total amount of I/O consumed by the session so far. This information can be useful when deciding which sessions to kill.
The application program that the user is using (for example, Microsoft Access).
The resource that is in conflict. This value often identifies a database and table.
The Resource data is reported directly from SQL Server.
SPID
The session unique identifier (Session Process ID).
Displays the SQL belonging to the session that is blocked and/or blocking.
The status of the session (Blocked, Blocking or both). For sessions at the head of the blocking chain (those that are not blocked), this also indicates if the session is Runnable or Sleeping.
The type of the lock request that is waiting (Database, Table, Page, Row, Key, Extent and so on).
Indicates how long this session has been waiting for the lock (measured in seconds). If the value displayed is 0, the session is not waiting.
您可以在附属支持站点上查找适用于戴尔*产品*的在线支持帮助。单击“继续”，转至适用于*产品*的正确支持内容和帮助。
The document was helpful.
选择评级
I easily found the information I needed.
© ALL RIGHTS RESERVED. 使用条款 隐私 Cookie Preference Center
Quest Software门户不再支持IE 8、9和10，建议将您的浏览器升级到最新版本的Internet Explorer或Chrome。
要升级到IE 11，请单击此处
要升级到Chrome，请单击此处
如果继续使用IE 8、9和10，您将无法充分利用我们所有出色的自助服务功能。
