Foglight for SQL Server (Cartridge) 5.9.2.1


Display Name	Description
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 Rate	The average time (seconds) spent by the various sessions consuming CPU cycles.
Executions	Indicates the number of times the SQL script per SQL Handle executed
Total CPU	The total CPU time consumed by the SQL executions
Total Physical Reads	The total number of physical reads carried out for executing the SQL statements
Total Logical Reads	The total number of logical reads carried out for executing the SQL statements
Total Elapsed Time	The total time consumed for carrying out the SQL statement executions
Total CLR Time	The total CLR time spent for executing the SQL statements
Total I/O	The total number of I/O operations that were carried out for executing the SQL statements
Total Wait Time	The total wait time spent while executing the SQL statements
SQL Hit Rate	The percentage of SQL Statements that found the required plan already in the cache. If a matching plan is found, SQL Server does not need to compile the query or the stored procedure. This can save a significant amount of CPU resources, and speed up SQL Server queries.

Traced SQL PA

Purpose

This collection retrieves information about the most recent statements executed by the selected session, including statements that have also already completed running. Each statement refers to a specific execution.

Type

SQL Server.

Collection Sampling Intervals

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

Collection Metrics


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.