Foglight for SQL Server (Cartridge) 5.9.4.20


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.

SQL Server Throughput

This collection provides SQL Server throughput metrics of the modification made, in both size (MB) and number of rows, as a result of carrying out the following queries: select insert, update, and delete.

IMPORTANT:


	IMPORTANT: Small tables (< 50 rows) are not included in any of this collection’s metrics.

NOTE:


	NOTE: While the Delete (MB), Insert (MB), Select (MB), and Update (MB) metrics handle the size in megabytes, the average Select rate, displayed in the chart, can appear in Kb/Sec when the rate values are extremely low.

Type

SQL Server Services.

Collection Sampling Intervals


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

Collection Metrics


Display Name	Description
Delete (MB)	The cumulative size (in megabytes) of I/O Delete operations performed on indexed and heaped tables in the selected SQL Server instance.
Insert (MB)	The cumulative size (in megabytes) of I/O Insert operations performed on indexed and heaped tables in the selected SQL Server instance.
Select (MB)	The cumulative size (in megabytes) of I/O Select operations performed on indexed and heaped tables in the selected SQL Server instance.
Update (MB)	The cumulative size (in megabytes) of I/O Update operations performed on indexed and heaped tables in the selected SQL Server instance.
Delete (Rows)	The cumulative size, in rows, of I/O Delete operations performed on indexed and heaped tables in the selected SQL Server instance.
Insert (Rows)	The cumulative size, in rows, of I/O Insert operations performed on indexed and heaped tables in the selected SQL Server instance.
Instance	The SQL Server instance name.
Select (Rows)	The cumulative size, in rows, of I/O Select operations performed on indexed and heaped tables in the selected SQL Server instance.
Update (Rows)	The cumulative size, in rows, of I/O Update operations performed on indexed and heaped tables in the selected SQL Server instance.

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) 5.9.4.20 - User Guide

SQL Server Host

SQL Server Load

SQL Server Services

SQL Server Throughput