Foglight for SQL Server (Cartridge) 7.3.0


Display Name	Description
Active Connections Percent	The percentage of active connections as part of the user sessions.
All Active Connections	The number of all SQL active connections.
Background Sessions	The total number of background sessions.
Blocked Connections	The total number of blocked sessions.
Blockers Connections	The total number of blocking sessions.
Connections Running DBCC	The total number of sessions running a DBCC command.
Foreground Sessions	The total number of foreground sessions.
Internal Connections	The number of internal connections of the SQL Server instance.
Machine Connections	The number of Client computers that currently have at least one SQL Server session.
Max Block Time	The maximum duration (in seconds) a current process was blocked.
Max Connections Allowed	The maximum number of user connections that SQL server allows.
Max Threads Allowed	The maximum number of threads that SQL server is configured to handle.
SQL Active Threads	The total number of the instance’s currently active threads.
SQL Executions	The total number of time that the selected statement executed during the specified time range. NOTE: This data is available only if StealthCollect is installed and configured
System Connections	The number of SQL Server system sessions.
Total Connections	The total number of SQL Server sessions, including user and system sessions.
User Active Connections	The number of non-system sessions that are actively processing in SQL Server or that are waiting on locks.
User Connections	The number of SQL Server user (non-system) sessions, excluding SQL Server Agent sessions.
User Inactive Connections	The number of non-system sessions that are not actively processing in SQL Server.
Worker Threads Used Percent	The percentage of active threads out of the maximum number of threads that SQL server is configured to handle.

SQL Server Global Variables

This collection provides general SQL Server parameters, such as I/O, networking, and database operational time.

Type

SQL Server.

Collection Sampling Intervals


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

Collection Metrics


Display Name	Description
CPU Busy	The total time the SQL Server instance has spent working since it was last started. The result is displayed in CPU time increments, or “ticks”, and is aggregated for all CPU units, so it may exceed the actual elapsed time. NOTE: To convert the value to microseconds, multiply it by @@TIMETICKS.
CPU Idle	The total time the SQL Server instance has been idle since it was last started. The result is displayed in CPU time increments, or “ticks”, and is aggregated for all CPU units, so it may exceed the actual elapsed time. NOTE: To convert the value to microseconds, multiply it by @@TIMETICKS.
I/O Errors	The number of I/O errors encountered by SQL Server during the specified time range.
Instance Packet Errors	The number of packet errors encountered by SQL Server during the specified time range.
Instance Packets In	The total number of network packets that were being sent to SQL Server from client applications during the specified time range.
Instance Packets Out	The total number of network packets that were being sent from SQL Server to Client applications during the specified time range.
Instance Packets Total	The rate at which network packets are being sent and received from SQL Server to client applications.
Instance Packet Errors	The rate at which SQL Server is encountering network packet errors.
Total Read Rate	Total number of physical reads carried out by SQL Server since the instance was last started.
Total Write Rate	Total number of physical writes carried out by SQL Server since the instance was last started.

SQL Server Host

Purpose

This collection provides general details about the SQL Server host, such as the networking environment and the host's I/O and CPU consumption.

Type

System.

Collection Sampling Intervals


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

Collection Metrics


Display Name	Description
CPU Name	The unique identifier of the CPU within all CPUs.
CPU Usage	Time spent by the various sessions that consume CPU cycles. This reading is taken directly from the operating system, rather than from SQL Server wait states.
Disk Utilization	The percentage of time the busiest disk spent serving system-wide I/O requests. This metric serves as a measure for the system I/O load. High values may indicate device bottleneck.
Free Virtual Memory	The current amount of virtual memory available in percent.
Individual CPU Usage	CPU utilization of a single processor.
Memory Max Percent	The maximum memory, in percent, which SQL Server can obtain from the host physical memory.
Network Bandwidth	The total network bandwidth used capacity of the specified network card in percent.
Network Interface	The name of the network interface.
Network Total Bandwidth	The total network bandwidth capacity of the specified network card.
Network Used Bandwidth	The total network bandwidth used capacity of the specified network card.
Physical Host	Physical name of the SQL Server instance host machine.
Physical Memory	The amount (in megabytes) of host physical memory.
Physical Memory Available	The amount (in megabytes) of physical memory available to applications.
Physical Memory Used	The amount (in megabytes) of physical memory used by applications.
Physical Memory Used Percent	The amount (by percentage) of physical memory used by applications.
Process CPU Utilization	Indicates the CPU use by a single process.
Run Queue Length	System average run queue. The CPU run queue is a holding area for threads and processes that require the CPU when the CPU is busy serving other processes. The run queue length is an indicator of whether the system has sufficient CPU resources for all the processes it executes. High values, along with high CPU utilization, indicate that the system requires faster or additional CPU units to handle the given load.
Total Virtual Memory	The current amount of total virtual memory.
Used Virtual Memory	The current amount (in megabytes) of used virtual memory.

SQL Server Load

Purpose

This collection displays general data about SQL operations on a SQL Server instance.

Type

System.

Collection Sampling Intervals


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

Collection Metrics


Display Name	Description
Attempted Connections	Number of attempted connections, either successful or unsuccessful since SQL Server was last started.
Session Logons	Number of sessions whose activity started during the current interval.
Session Logons Delta Rate Calculation	The rate per second of sessions whose activity started during the current interval.

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Foglight for SQL Server (Cartridge) 7.3.0 - User Guide

SQL Server Connections Summary

SQL Server Global Variables

SQL Server Host

SQL Server Load