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 specifies the Log shipping tree and the primary and secondary servers' file location and operations.
SQL Server.
Real-time
20
SPID
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.
Status
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.
60
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.
This collection monitors how SQL Server stores and manages its memory.
% Total Server Memory
The total percentage of dynamic memory that the server is currently consuming.
This value is calculated as follows:
100 * (Total Server Memory / Physical RAM)
Cache Memory
Total amount of dynamic memory (in megabytes) that the server is using for the dynamic SQL cache.
Connections Memory
Memory (in megabytes) allocated to keeping track of each connection's attributes.
Locks Memory
Memory (in megabytes) allocated to keeping track of locks.
Max SQL Server Memory
The maximum amount of dynamic memory that the instance is allowed to consume.
Memory Growth Pressure
Relative amount of additional memory (presented as a percentage) that SQL Server is willing to consume.
Values higher than 20 percent might indicate that the system is low on physical memory.
The memory growth pressure value is calculated as follows:
100 – ((100 * Total Server Memory)
Target Server Memory)
Optimizer Memory
Work area for the Optimizer in megabytes.
Sort Hash Memory
Memory in megabytes used for the Sort, Hash, and Index operations.
Target Server Memory
The maximum memory allocation size in megabytes SQL Server can reach at a current time (this value may change during SQL Server's work).
Values significantly higher than Total Server Memory might indicate that the system is low on physical memory.
Total Server Memory
The total amount of dynamic memory (in megabytes) that the server is currently consuming.
계열사 지원 사이트에서 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을 계속 사용할 경우 당사가 제공하는 뛰어난 셀프서비스 기능 모두를 최대한으로 활용하실 수 없습니다.
