Foglight for SQL Server (Cartridge) 5.9.7.20


Display Name	Description
Database ID	Database ID
Database Name	Database name
Resource Pool Name	The name of the resource pool that is mapped to this database. This resource pool controls total memory available to memory-optimized tables in this database.
Total Allocated Tables	The total amount of memory allocated for the tables.
Total Allocated Indexes	The total amount of memory allocated for the Indices.
Total Allocated System	The total amount of memory allocated for the system.
Pool Consumption Percentage	Total database memory out of available pool size.
Total Used Tables	The total amount of memory used by the tables, including row versions.
Total Used Indexes	The total amount of memory used by the indices, including row versions.
Total Used System	The total amount of memory used by the system, including row versions.

Instance Wait Categories

Purpose

This collection provides data for a list of SQL processes' wait events, divided by resource event categories.

Type

System.

Collection Sampling Intervals


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

Collection Metrics


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.