Foglight for SQL Server (Cartridge) 5.9.2.1


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.

SQL Server Services

This collection indicates the status of SQL Server-related services, mail provides, log shipping and clustering.

Type

SQL Server Services.

Collection Sampling Intervals


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

Collection Metrics


Display Name	Description
Analysis Services	The status of Analysis Services service.
Cluster Servers Down	Number of cluster nodes that are down or unreachable.
Distributed Transaction Coordinator	The status of Distributor Transaction Coordinator service.
Integration Services	The status of SQL Server Integration Services service.
Last Alert	Number of alerts raised by SQL Server since the specified time.
Last Job Failed	Number of failed jobs since the specified time.
Log Shipping	The status of Log Shipping.
MS Full Text Search	The status of MS Full Text Search service.
Non Preferred Node	Number of cluster nodes that are declared as preferred servers.
Reporting Services	The status of SQL Server Reporting Services service.
SQL Agent	The status of SQL Agent service.
SQL Server Active Directory Helper	The status of SQL Server Active Directory Helper (ADH) service.
SQL Server Browser	The status of SQL Server Browser Service.
SQL Server Mail	The status of SQL Server Mail service.
SQL Server VSS Writer	The status of SQL Server VSS writer Service.
State Changed	The time the service state was last changed.

Documentos relacionados

The document was helpful.

Selecione a classificação

I easily found the information I needed.

Selecione a classificação

Selecione seu produto:

Para podermos atendê-lo melhor, informe o Propósito de seu chat:

Soluções recomendadas para seu problema

Foglight for SQL Server (Cartridge) 5.9.2.1 - User Guide

SQL Server Global Variables

SQL Server Host

SQL Server Load

SQL Server Services