Foglight for SQL Server (Cartridge) 7.3.0


Display Name	Description
Active Time	Sum of all active wait events; equal to the session total activity within the specified time range.
CLR Wait	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 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.
Database	The name of the database where the session is running.
Degree of Parallelism	Average number of SQL Server threads assigned to serve the current SQL statement.
End Time	The time when the selected statement’s execution ended.
Event (list)	The list of wait events for the selected SQL statement.
Event Wait (list)	Time spent on the wait events for the selected SQL statement.
Instance CPU Usage	The amount of CPU time that the SQL Server instance consumed.
IO Wait	Time spent by the various processes waiting for the completion of physical I/O operations.
Latch Wait	Time spent waiting for internal locks (latches) to be released.
Lock Wait	Time spent by the various sessions waiting for a blocking lock (held by another session) to be released.
Log Wait	Time spent waiting by the various processes waiting for a Log operation to complete.
Memory Wait	Time spent by the various sessions waiting for memory resources to be made available.
Network Wait	Time spent by the various sessions waiting for network I/O operations to complete.
Other Wait	Miscellaneous instance waits consisting of infrequent or otherwise special purpose wait states that should, in most cases, be very close to 0.
Physical IO	The total amount of I/O operations carried out so far by the statement.
Remote Provider Wait	The time spent by the various processes waiting for a remote OLEDB call to complete or DTS synchronization.
SPID	The process ID of the blocking session.
SQL Text	The short text of the SQL statement.
Start Time	The time when the SQL statement started.

Usability

Purpose

This collection retrieves instance usability based on response time and instance availability.

Type

SQL Server.

Collection Sampling Intervals


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

Collection Metrics


Display Name	Description
Availability	Indicates whether the SQL Server instance is available.
Instance Response Time	The full round-trip response time (in milliseconds) of a query representative of general workload (select 1, by default).
Instance Up Since	The SQL Server startup time.
Instance Up Time	The amount of time that the SQL Server instance was running during the current interval. If the instance is down, no data collection occurs. Therefore, if this metric value is less than the interval length, the value of this metric reflects only the active portion of the interval.
Instance Unavailable	The relative amount of time that the SQL Server instance was down during the current interval. If the instance is down, no data collection occurs.
Connection Time	The time when the connection was established.
OS Connect Availability	Indicates whether a connection is available.