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.
라이브 도움말 보기
등록 완료
로그인
가격 산정 요청
영업 담당자에게 문의
제품 번들을 선택했습니다. 귀하의 요청에 더 적합한 서비스를 제공해 드릴 수 있도록 개별 제품을 선택해 주십시오. *
지금은 채팅에 회신할 수 있는 기술 지원 엔지니어가 없습니다. 즉각적인 서비스를 받으려면 당사의 서비스 요청 양식을 사용하여 요청을 제출하십시오.
다음 문서의 설명에 따라 문제를 해결할 수 있습니다.
This collection provides a list of locks used within a SQL Server instance, grouped by the lock type, mode, and status.
SQL Server.
Real-time
60
SPID
The server process ID of the current user process.
Login Time
The time the session was created.
Login Name
SQL Server Login name.
Database
The database that is being used by the current process.
Index Name
The index that is being used by the current process (if any).
Object Name
The name of the currently locked object.
Count
The number of locks that share the same object and type.
Lock Type
The type of the resource that is currently being locked (Database, Table, Page, Row, Extent and so on).
Mode
The kind of lock that is being applied to the resource (Shared, Exclusive, Update, IntentShared, IntenExclusive and so on).
Status
The status of the lock can be one of the following:
This collection specifies the Log shipping tree and the primary and secondary servers' file location and operations.
20
The SQL process ID of the process that ran the query.
Rowset Key
The row identifier.
Owner
The current primary server.
Server Name
The name of the server (primary server for the parent node, and secondary server for all subsequent child nodes).
Database Name
Refers to either of the following databases:
Flag Error
An indicator of an error that occurred.
Threshold
The maximum allowed time (in minutes) before a Log Shipping alert occurs.
This parameter can refer to either of the following values:
Threshold Alert
The alert displayed in the Error Log drilldown if the threshold is exceeded.
Threshold Alert Enabled
The alert displays only if it is enabled.
Last Change
Last Change Type
The type of the activity that resulted in the log shipping’s most recent change of state (Backup, Copy or Restore).
Last Backup Filename
The name of the file that was most recently backed up.
Last Backup Last Updated
The time at which the most recent backup operation was carried out.
Outage
During an outage, no alerts will occur when thresholds are exceeded (for both the parent and child nodes).
If this field is blank, no outage will take place.
Backup In Sync
Indicates either of the following backup statuses:
Backup Delta
The last time a log transaction backup occurred in the primary server.
Last Copied Filename
The last backup file that was copied to the secondary server.
Last Copied Last Updated
The time when the backup file was most recently copied from the primary to the secondary server.
Last Loaded Filename
The name of the backup file that was most recently restored to the secondary server.
Last Loaded Last Updated
The time when the backup file was most recently restored to the secondary server.
Copy Delta
The date when the transaction log backup file was most recently copied to the secondary server.
Copy Enabled
Indicates whether copying is enabled.
Load Enabled
Indicates whether loading is enabled.
Load in Sync
The load synchronization can have either of the following statuses:
Load Delta
The date of the last restored transaction log load file to the secondary server.
Primary Server Time
The current timestamp at the primary server.
Secondary Server Time
The current timestamp at the secondary server.
Monitor Server Time
The current timestamp at the monitored server.
The collection shows Log Shipping Errors.
900
Online
Offline
Session ID
The session ID for the backup/copy/restore/job.
Sequence Number
An incremental number indicating the correct order of information for errors that span multiple records.
Log Time
The date and time at which the record was created.
The name of the server.
DB Name
The name of the database.
Agent Type
The type of log shipping job.
0 = Backup.
1 = Copy.
2 = Restore.
Agent Type Description
The description of the Agent Type.
Message
Message text.
Source
The source of the Error Message.
If no Error for last hour - OK.
If an error found on the last 15 minutes - ERROR.
If there is an error between last hour and last 15 minutes nothing would be raised so the last error status should remain.
This collection displays the logical disk activity for each logical disk.
System.
300
Disk Queue Length
Disk Queue length tracks the average number of I/O requests, from all disks in the system, which are queued and waiting for a disk during a sampled interval. This figure may include I/O activity generated by processes other than SQL Server.
Values that exceed the threshold set in this metric indicate a bottleneck.
A flag indicating a threshold for the number of I/O requests that were outstanding on the busiest disk in the system.
Disk Percentage Used
The percentage of used space on the specified partition.
Disk Partition
The logical disks to which the Disk Queue Length value refers.
Partition Free Pct
The percentage of free space on the specified partition.
Partition Free Space
The amount of free space (in megabytes) on the specified partition.
Partition Total Space
The total space (in megabytes) on a particular partition.
계열사 지원 사이트에서 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을 계속 사용할 경우 당사가 제공하는 뛰어난 셀프서비스 기능 모두를 최대한으로 활용하실 수 없습니다.
