Foglight for SQL Server (Cartridge) 7.1.0


Display Name	Description
Active Time	Sum of all active wait events; equal to the session total activity within the specified time range.
Backup Recovery Wait	The average number of active sessions waiting for the completion of backup or recovery tasks during the selected time range.
CLR Wait	Time spent by the various sessions waiting for CLR code execution to complete.
CLR Wait Percent	Percentage of time spent by the various sessions waiting for CLR code execution to complete.
CPU Usage	Time spent by the various sessions consuming CPU cycles. This reading is taken directly from the operating system, rather than SQL Server wait states.
CPU Usage Percent	Percentage of time spent by the various sessions consuming CPU cycles. This reading is taken directly from the operating system, rather than from SQL Server wait states.
CPU Usage Rate	Percentage of time spent by the various sessions waiting for CLR code execution to complete.
CPU Wait	Time spent by the various sessions waiting in the systems run queue for CPU cycles. This reading is calculated from the operating system readings, rather than SQL Server wait states.
CPU Wait Percent	Time spent by the various sessions waiting in the system's run queue for CPU cycles. This reading is taken directly from the operating system, rather than from SQL Server wait states.
CPU Wait Rate	Time spent per second by the various sessions waiting in the system's run queue for CPU cycles. This reading is taken directly from the operating system, rather than from SQL Server wait states.
Cursor Synchronization Wait	Time spent by the various sessions waiting for cursor synchronization operations to complete.
Cursor Synchronization Wait Rate	The average number of active sessions waiting for the completion of cursor synchronization operations during the specified time range.
Database Replication Wait	Time spent by the various sessions waiting for replication synchronization events to complete.
Deferred Task Worker Wait	Time spent by the various sessions waiting for I/O requests; this wait indicates that either a large number of suspect pages are encountered or the disk subsystem is overloaded.
Distributed Transaction Wait	Time spent by the various sessions waiting for various distributed transaction events to complete.
External Procedure Wait	Time spent by the various sessions waiting for external procedures to end.
Full Text Search Wait	Time spent by the various sessions waiting for full text synchronization operations.
Hosted Components Wait	Time spent by the various sessions waiting for hosted components, such as, but not exclusively, CLR.
I/O Bulk Load Wait	Time spent by the various sessions waiting for a bulk load I/O to finish.
I/O Completion Wait	Time spent by the various sessions waiting for I/O operations to complete.
I/O Data Page Wait	Time spent by the various sessions waiting to latch a buffer for an I/O request; this wait is related to issues with the disk I/O subsystem.
I/O Wait	Time spent by the various sessions waiting for physical I/O operations to complete.
Idle	Idle time.
Internal Cache Latch Wait	Time spent by the various sessions waiting for latches that are not buffer latches or savepoint latches. Typically, this event can only be treated by partitioning data to provide more cache pages.
Latch Buffer Wait	Time spent by the various sessions waiting to latch a buffer that is not an I/O request.
Latch Savepoint Wait	Time spent by the various sessions waiting to synchronize commits to marked transactions.
Latch Wait	Time spent waiting for internal locks (latches) to be released.
Lock Bulk Update Wait	Time spent by the various sessions waiting to acquire bulk update locks.
Lock Exclusive Wait	Time spent by the various sessions waiting to acquire exclusive locks.
Lock Intent Wait	Time spent by the various sessions waiting to acquire intent locks.
Lock Schema Wait	Time spent by the various sessions waiting to acquire schema locks.
Lock Shared Wait	Time spent by the various sessions waiting to acquire shared locks.
Lock Update Wait	Time spent by the various sessions waiting to acquire update locks.
Lock Wait	Time spent by the various sessions waiting for a blocking lock (held by another session) to be released.
Log Buffer Wait	Time spent by the various sessions waiting for space in the log buffer or otherwise waiting for memory to be made available to write log records.
Log Other Wait	Time spent by the various sessions waiting for miscellaneous logs.
Log Synchronization Wait	Time spent by the various sessions waiting to see whether log truncation frees log space.
Log Wait	Time spent waiting by the various processes waiting for a Log operation to complete.
Log Write Wait	Time spent by the various sessions waiting for outstanding I/Os to finish, or waiting for log flushes to complete.
Memory Wait	Time spent by the various sessions waiting for memory resources to be made available.
Network HTTP Wait	Time spent by the various sessions waiting for outstanding HTTP connections to complete and exit.
Network I/O Wait	Time spent by the various sessions waiting for network packets.
Network IPC Wait	Time spent by the various sessions waiting for sub-tasks to generate data; long waits are indicative of unexpected blockages.
Network Mirror Wait	Time spent by the various sessions waiting for sub-tasks to generate data; long waits are indicative of unexpected blockages.
Network Wait	Time spent by the various sessions waiting for network I/O operations to complete.
Network Wait Percent	Percentage of time spent by the various sessions waiting for network I/O operations to complete.
Non CLR Wait	Overall active time that does not include CLR wait time.
Non CLR Wait Rate	The average number of active sessions waiting for all wait events, excluding CLR wait, during the specified time range.
Non CPU Wait	Overall active time that does not include CPU wait time.
Non CPU Wait Rate	The average number of active sessions waiting for all wait events, excluding CPU wait, during the specified time range.
Non I/O Wait	Overall active time during the specified time range, excluding time spent on I/O-related wait events.
Non Latch Wait	Overall active time during the specified time range, excluding time spent on latch-related wait events.
Non Latch General Wait	Overall active time during the specified time range, excluding time spent on general latch-related wait events.
Non Lock Wait	Overall active time during the specified time range, excluding time spent on lock-related wait events.
Non Log Wait	Overall active time during the specified time range, excluding time spent on log-related wait events.
Non Memory Wait	Overall active time during the specified time range, excluding time spent on memory-related wait events.
Non Network Wait	Overall active time during the specified time range, excluding time spent on network-related wait events.
Non Other Wait	Overall active time during the specified time range, excluding time spent on general other wait events.
Non Remote Provider Wait	Overall active time during the specified time range, excluding general remote provider wait time.
OLEDB Provider Full Text Wait	Time spent by various processes waiting for the Microsoft Full Text Engine for SQL Server.
Other Miscellaneous Wait	Time spent by the various sessions waiting for miscellaneous database operations.
Other Wait	Miscellaneous instance waits consisting of infrequent or otherwise special purpose wait states that should, in most cases, be very close to 0.
Parallel Coordination Wait	Time spent by the various sessions waiting for parallel coordination tasks to complete. This is the time spent by the various processes coordinating parallel query threads and exchanging data.
Remote Provider Wait	The time spent by the various processes waiting for a remote OLEDB call to complete or DTS synchronization.
Service Broker Wait	Time spent by the various sessions waiting for Service Broker event handlers and endpoints.
Synchronous Task Wait	Time spent by the various sessions waiting for tasks started synchronously (most SQL Server processes are started asynchronously).
XTP Transaction Wait	Time spent waiting for in-memory transaction events.
XTP Wait	Time spent waiting for in-memory OLTP (XTP) related events.
XTP Miscellaneous Wait	Time spent waiting for in-memory miscellaneous events. Those events are not related to transactions, log or natively compiled stored procedures.
XTP Log write Wait	Time spent waiting for in-memory log and checkpoint related events.
XTP Procedure Wait	Time spent waiting for events related to natively compiled stored procedures.

Instance Wait Events

Purpose

This collection provides data for a list of SQL Server wait events, divided by wait events.

Type

System.

Collection Sampling Intervals


Frequency Mode	Collection Interval (In Seconds)
Real-time	20
Online	60
Offline	300

Collection Metrics


Display Name	Description
Wait Event Name	Internal wait event name.
Wait Time	Total wait time for this wait event type, in seconds.

Job Messages

This collection provides a list of the job messages that were displayed as a result of running a specific SQL Server job.

Type

SQL Server.

Collection Sampling Intervals

This collection is an on-demand collection, which has no pre-defined sampling intervals.

Text, if any, of a SQL Server error.

Step Name

The name of the step.

Step ID

The ID of the step in the job.

SQL Message ID

ID of any SQL Server error message, which is returned if the job failed.

SQL Message Severity

The severity of any SQL Server error.

Run Status

Status of the job execution.

The run status can have one of the following values:

•

•

•

•

•

The date and time when the job or step started execution. For an In Progress history, this is the date and time when the history was written.

Run Duration

The time, in seconds, which has elapsed since the beginning of the execution of the job or step format.

Latches and Locks

Purpose

This collection provides statistic details about latches and locks, such as wait time, requests and occurrences.

Type

System.

Collection Sampling Intervals


Frequency Mode	Collection Interval (In Seconds)
Real-time	20
Online	60
Offline	300

Collection Metrics


Display Name	Description
Average Latch Hit Wait Time	The wait time of latch requests that were satisfied.
Average Lock Duration	Average duration of blocked lock requests (100 * Lock Wait) /Blocked Lock Requests.
Average Lock Requests Wait Time
Average Lock Wait Time	The average wait time, in milliseconds, of lock requests that were satisfied.
Blocked Lock Requests	Number of lock requests that could not be satisfied immediately, causing the caller to block and wait before acquiring the lock.
Blocked Lock Requests Ratio	The percentage of lock requests that required the caller to wait before acquiring the lock. A high percentage (over 20 percent), along with high Lock Wait, indicate that the system is not handling locks well and concurrency mechanisms need to be tuned. Excessive blocking can be a major cause of poor application performance, as the user of an application often does not realize that they are waiting on a lock held by another user. From their point of view, it often seems like their application has stopped responding. (100 * Blocked Lock Requests) / Lock Requests
Latch Wait Count	Number of latch requests that could not be satisfied immediately, causing the caller to block and wait before acquiring the latch.
Lock Requests	Number of new locks and lock conversions requested from the lock manager.
Lock Timeouts	The number of lock timeouts. By default, SQL Server never times out locks. However, many applications issue a SET LOCK_TIMEOUT statement to cause SQL Server to time out their locks after the specified interval. This metric shows how often these timeouts are being exceeded.
Lock Timeouts Bigger Than Zero	The number of lock timeouts. By default, SQL Server never times out locks (they will wait forever). However, many applications issue a SET LOCK_TIMEOUT statement to cause SQL Server to timeout their locks after the specified interval. This metric shows how often these timeouts are being exceeded.
Lock Wait Time	Total wait time, in milliseconds, for all lock requests that resulted in a wait.
Number Of Deadlocks	The number of lock requests that resulted in a deadlock. A Deadlock occurs when multiple SQL Server sessions request conflicting locks in such a way that two locks are blocked by one another.
Number Of Super Latches	Number of latches that are currently SuperLatches. Super Latches (or Sub-Latches) are latches that are generally used when data is accessed frequently (latches that are in shared lock mode (SH)). A regular latch is often “Promoted” to a Super/Sub latch in order to reduce the latch acquired on each lookup. Thus, when data is accessed many times for carrying out a read-only operation, the “newly promoted” Super/Sub latch will handle all requests for this data. An example to a Super/Sub latch would be an index root page accessed frequently.
Super Latch Demotions	Number of SuperLatches that have been demoted to regular latches. A latch is demoted when SQL Server determines that no thread requests a data help by Super/Sub latch, or when SQL Server needs to write to that data resource and need to acquire exclusive access to that source.
Super Latch Promotions	Number of latches that have been promoted to SuperLatches. A regular latch is often “Promoted” to a Super/Sub latch in order to reduce the latch acquired on each lookup. Thus, when data is accessed many times for carrying out a read-only operation, the “newly promoted” Super/Sub latch will handle all requests for this data. An example to a Super/Sub latch would be an index root page accessed frequently.
Total Latch Wait Time	The total amount of time, in milliseconds, that latch requests spent waiting during the last second.

제품을 선택하십시오.

더 나은 서비스 제공을 위해 채팅 목적을 작성해 주십시오.

문제에 대한 권장 솔루션

Foglight for SQL Server (Cartridge) 7.1.0 - User Guide

Instance Wait Categories

Instance Wait Events

Job Messages

Latches and Locks