予定されていた保守を実行中のため、サポートサイトでのフォームの送信が一時的に利用できません。 すぐにサポートが必要な場合は、テクニカルサポートまでお問い合わせください。 ご不便をおかけして申し訳ありません。
オンラインヘルプの参照
登録の完了
サインイン
価格設定をリクエスト
営業担当に連絡
製品バンドルが選択されました。 リクエストにより良く対応できるように、個別の製品を選択していただけますか? *
現在、テクニカル・サポート・エンジニアはお客様のチャットに対応できません。 迅速にサービスを受けられるよう、サービス・リクエスト・フォームを使用して
お客様の説明に基づいて、以下の記事が問題解決に役立つ可能性があります。
This collection displays the logical disk activity for each logical disk.
System.
Real-time
20
Online
60
Offline
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.
Threshold
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.
This collection retrieves general data, such as role, state and status, about each database involved in the mirroring process.
SQL Server.
900
Connection Timeout
Defines the number of seconds that the principal database can be in Disconnected state, before the mirroring session will actually run a failover scenario to the mirroring database.
Database Name
The name of the database.
End Log LSN
The actual LSN (Log Sequence Number) of the mirroring session, This value should be equal to the Failover LSN value.
Failover LSN
The LSN (Log Sequence Number) value that the mirroring database should have in order to enable a smooth failover.
Mirror
The name of the instance whose role in the mirroring process is Mirror.
Mirroring Role
The role the database takes in the mirroring process; either principal or mirror.
Mirroring Status
Indicates the severity determined based on the database state: Normal, Warning or Critical.
Partner Name
The server network address defined for the Partner.
Principal
The name of the instance whose role in the mirroring process is Principal.
Redo Queue
The redo queue size. This size can be either lett Unlimited or defined in MB.
Replication LSN
The LSN (Log Sequence Number) used by the replication session (If such a session exists).
Role Sequence
A cumulative number that indicates the number of role switches that took place between the two partners involved in the mirroring process.
Safety Level
The safety level at which the mirroring session is configured to work (high availability /high performance).
Witness Name
The server network address defined for the Witness.
Witness State
The state of the Witness instance (valid only when the High Safety level is configured).
This collection retrieves data regarding performance and data flow-related issues between the databases involved in the mirroring operation.
Commit Acknowledgment Delay
Indicates a delay in waiting for acknowledgement of unterminated transaction commit. This metric is specific to the principal database, and holds values only when a Full safety level is configured.
Log Remaining For Undo
Indicates the size of transaction logs in the mirror database that remain for recovering the mirror database to its operative state. This metric holds data only after a failover has occurred.
Log Cache Redone
The amount of transaction log in MB that is being read from redo cache rather than from the transaction log. Constantly low values of this metric indicate that the transaction log is arriving faster than it can be read by the redo task. This metric is specific to the mirror database.
Log Harden Wait Time
The amount of time spent waiting for the log to be written to the mirroring database. High values of this metric can indicate that the disk of the mirroring database is loaded. This value is specific to the mirror database.
Log Received
Indicates the rate in MB of log received from the principal database. This metric is specific to the mirror database.
Log Rolled Forward
The size in MB of log that was rolled forward on the mirror database. This value is specific to the mirror
Log Scanned For Undo
Indicates the size of transaction logs in the mirror database that were scanned for Undo. This metric holds data only after a failover has occurred, as the log scanning is carried out in order to restore the mirror database to its operative state.
Log Send Flow Buffer Wait
The amount of time the mirroring session had to wait to use the mirroring flow control buffer. This value is specific to the principal database.
Log Sent
Indicates the rate in MB of log sent from the principal to the mirror database. This metric is specific to the principal database.
Log Sent From Cache
Indicates the amount of log, in MB, sent from the principal database cache rather than straight from the transaction log.
As sending from the cache is much faster and more efficient, this metric's values should be as high as possible. Constantly low values indicate that the transaction log generation rate is faster than the rate at which it is sent to the mirror database. This value is specific to the principal database.
Mirroring Roundtrip (Latency)
Indicates the latency of the mirroring session.
Occupied Cache Percent
The percentage of the occupied cache within the selected database.
Roll Forward Queue
Total size in MB that remains to roll forward to the mirroring database. This value is specific to the mirror database.
Send Queue
Total size in MB of data waiting to be sent to the mirroring database. This value is specific to the principal database.
Write Commit
This metric, which holds values only when a Full safety level is configured, indicates the number of transactions in the principal database that had to wait for a write commit in the mirror database's transaction log.
Low values of this metric indicate a bottleneck.
Quest *product*のオンラインサポートヘルプは、関連会社のサポートサイトで参照できます。「Continue（続行）」をクリックすると、*product*の適切なサポートコンテンツとアシスタンスへ移動します。
The document was helpful.
評価を選択
I easily found the information I needed.
Quest Softwareポータルでは、IE8、9、10のサポートを終了しました。ブラウザを最新バージョンのInternet ExplorerまたはChromeにアップグレードすることをお勧めします。
IE 11へのアップグレード: ここをクリック
Chromeへのアップグレード: ここをクリック
の優れたセルフサービス機能を最大限に活用していただけるよう、IE8、9、10以外のブラウザをぜひご利用ください。
