Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
라이브 도움말 보기
등록 완료
로그인
가격 산정 요청
영업 담당자에게 문의
제품 번들을 선택했습니다. 귀하의 요청에 더 적합한 서비스를 제공해 드릴 수 있도록 개별 제품을 선택해 주십시오. *
지금은 채팅에 회신할 수 있는 기술 지원 엔지니어가 없습니다. 즉각적인 서비스를 받으려면 당사의 서비스 요청 양식을 사용하여 요청을 제출하십시오.
다음 문서의 설명에 따라 문제를 해결할 수 있습니다.
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.
계열사 지원 사이트에서 Quest *제품*에 대한 온라인 지원 도움말을 볼 수 있습니다. 올바른 *제품* 지원 콘텐츠 및 지원에 연결하려면 계속을 클릭하십시오.
The document was helpful.
평가 결과 선택
I easily found the information I needed.
Quest Software 포털은 더 이상 IE 8, 9, 10을 지원하지 않습니다. 브라우저를 최신 버전의 Internet Explorer나 Chrome으로 업그레이드하는 것이 좋습니다.
IE 11로 업그레이드 여기를 클릭
Chrome으로 업그레이드 여기를 클릭
IE 8, 9 또는 10을 계속 사용할 경우 당사가 제공하는 뛰어난 셀프서비스 기능 모두를 최대한으로 활용하실 수 없습니다.
