Foglight for SQL Server (Cartridge) 5.9.5.20


Display Name	Description
Creation Date	Indicates the date the SQL statement was first run, thereby allowing the creation of SQL statement statistics
Diff. From Executions	Indicates the incremental difference in the number of SQL executions since the last sample.
Diff. From Total CLR Time	Indicates the incremental difference, since the last sample, in the total CLR time spent for executing the SQL statements.
Diff. From Total CPU	Indicates the incremental difference, since the last sample, in the total CPU time consumed by the SQL executions.
Diff. From Total Elapsed Time	Indicates the incremental difference, since the last sample, in the total time consumed for carrying out the SQL statement.
Diff. From Total I/O	The incremental difference, since the last sample, in the total number of I/O operations that were carried out for executing the SQL statements.
Diff. From Total Logical Reads	The incremental difference, since the last sample, in the total number of logical reads carried out for executing the SQL statements.
Diff. From Total Physical Reads	The incremental difference, since the last sample, in the total number of physical reads carried out upon executing SQL statements.
Diff. From Total Wait Time	The incremental difference, since the last sample, in the total wait time consumed upon executing SQL statements.
Executions	Indicates the number of times the SQL script executed for a unique SQL Handle.
Last Executed	Indicates the last time the SQL statement was executed (last run).
Plan Handle	Provides a unique identification of a SQL statement execution plan.
Query Hash	Query hash value indicates the logic behind a SQL script. Similar SQL queries (that is, SQL queries that differ by literal rather than logical values) have the same query hash value. Therefore, if the execution of such queries results in different query plan hash values, the reason for the difference is most probably the data against which the queries were executed.
SQL Handle	Provides a unique identification of a SQL batch script.
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.
Statement End Offset	A SQL batch may be combined of multiple SQL statements. While the SQL handle identifies the batch as a whole, this metric provides a unique identification of a specific SQL statement, by indicating the end position of the statement within the SQL batch.
Statement Start Offset	A SQL batch may be combined of multiple SQL statements. While the SQL handle identifies the batch as a whole, this metric provides a unique identification of a specific SQL statement, by indicating the start position of the statement within the SQL batch.
Total CLR Time	The total CLR time spent for executing the SQL statements.
Total CLR Time Per Exec	The average CLR time spent for executing a single CLR execution.
Total CLR Time Rate Top SQL	The total CLR time per second spent for executing the CLR execution.
Total CPU	The total CPU time consumed by the SQL executions.
Total CPU Per Exec	The average CPU time spent for executing a single SQL statement.
Total Elapsed Time	The total time consumed for carrying out the SQL statement executions.
Total Elapsed Time Per Exec	The average time spent for executing a single SQL statement.
Total I/O	The total number of I/O operations that were carried out for executing the SQL statements.
Total I/O per Exec	The average number of I/O operations carried out for executing a single SQL statement.
Total I/O Rate Top SQL	The total number of I/O operations per second that were carried out for executing the SQL statements.
Total Logical Reads	The total number of logical reads carried out for executing the SQL statements.
Total Logical Reads Per Exec	The average number of logical reads carried out for executing a single SQL statements.
Total Logical Reads Rate Top SQL	The total number of logical reads per second that were carried out for executing the SQL statements.
Total Physical Reads	The total number of physical reads carried out for executing the SQL statements.
Total Physical Reads Per Exec	The average number of physical reads carried out per execution of a single SQL statement.
Total Wait Time	The total wait time spent while executing the SQL statements.
Total Wait Time Per Exec	The average time spent on wait events while executing a single SQL statement.