Foglight for SQL Server (Cartridge) 7.1.0


Display Name	Description
Alert Name	The name of the alert that was raised.
Alert Type	The type of alert.
Database	The name of the database where the alert was raised.
Definition	A brief description of the specified alert.
Enabled	The status of the alert.
Last Occurred	The previous time the alert was raised.
Occurrences	The number of the alert’s occurrences.

Agent Job List

Purpose

This collection provides a list of all SQL Server Agent's scheduled jobs, including their status and duration.

Type

SQL Server.

Collection Sampling Intervals


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

Collection Metrics


Display Name	Description
Category	The SQL Agent job category assigned to this job.
Current Server Time	The Server time at the time the query ran.
Current Status	The current status of the job (Running or Inactive).
Current Step Number	Displays the current step number if the job is currently running.
Description	A brief description of the job.
Is Enabled	Determines whether the job can be run.
Job Name	The name of the job.
Job State	The current state of the job.
Jobs Failed Threshold	A flag indicating that a job has failed.
Jobs Retry Threshold	A flag indicating that a job retry has occurred.
Last Run Duration	Indicates how long the last run took (displayed in the d hh:mm:ss format).
Last Run Finish Time	The time the job finished.
Last Run Message	The last message associated with that step in the job.
Last Run Outcome	The result of the last run (Success or Fail).
Last Run Outcome Threshold	A flag indicating that the last run’s outcome is a job retry.
Last Run Time	The date/time on which the job last ran.
Long Running Job Threshold	A flag indicating that a long running job has occurred.
Next Run Time	The date and time of the next scheduled run.
Raise Alarm	Indicates whether the job raised an alarm the last time it ran.
Short Job Name	The short name of the job (in cases where the job name is too long to be displayed in full).

Always On

It includes three separated collections: Always On Cluster General, Always On Cluster Members, and Always On Cluster Network.

Type

SQL Server.

Collection Sampling Intervals


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

Cluster General

Collecting SQL Server Always On Cluster Configuration.

Collection Metrics


Display Name	Description
Cluster Name	Name of the WSFC cluster that hosts the instances of SQL Server that are enabled for AlwaysOn Availability Groups.
Quorum Type	Description of quorum_type, one of: NODE_MAJORITY, NODE_AND_DISK_MAJORITY, NODE_AND_FILE_SHARE_MAJORITY,NO_MAJORITY:_DISK_ONLY
Quorum State	State of the WSFC quorum, one of: 0 = Unknown quorum state 1 = Normal quorum 2 = Forced quorum
Member Name	Member name, which can be a computer name, a drive letter, or a file share path.
Member Type	The type of member, one of: 0 = WSFC node 1 = Disk witness 2 = File share witness

Cluster Members

Collecting SQL Server Cluster Members Configuration.

Collection Metrics


Display Name	Description
Member Name	Member name, which can be a computer name, a drive letter, or a file share path.
Member Type	The type of member, one of: 0 = WSFC node 1 = Disk witness 2 = File share witness
Member State	The member state, one of: 0 = Offline, 1 = Online
Network Subnet IP	Network IP address of the subnet to which the computer belongs. This can be an IPv4 or IPv6 address.

Cluster Network

Collecting SQL ServerCluster Network Configuration.

Collection Metrics


Display Name	Description
Member Name	A computer name of a node in the WSFC cluster.
Network Subnet IP	Network IP address of the subnet to which the computer belongs. This can be an IPv4 or IPv6 address
Network Subnet IPv4 Mask	The network subnet mask that specifies the subnet to which the IP address belongs. NULL = IPv6 subnet.
Network Subnet Prefix Length	Network IP prefix length that specifies the subnet to which the computer belongs.
Is Public	Whether the network is private or public on the WSFC cluster, one of: 0 = Private 1 = Public
Is IPv4	Type of the subnet, one of: 1 = IPv4 0 = IPv6

Availability Groups

It collects SQL Server Availability Groups.

Type

SQL Server.

Collection Sampling Intervals


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

Collection Metrics


Display Name	Description
Availability Group Name	Name of the availability group. This is a user-specified name that must be unique within the Windows Server Failover Cluster (WSFC) cluster.
Availability Group ID	Unique identifier (GUID) of the availability group.
Ag Resource ID	Unique ID of the availability group as a resource in the WSFC cluster.
Ag Databases Group ID	Unique WSFC databases Group ID of the availability group.
Primary Replica	Name of the server instance that is hosting the current primary replica. NULL = Not the primary replica, or, unable to communicate with the WSFC failover cluster.
Primary Recovery Health	Indicates the recovery health of the primary replica, one of: 0 = In progress 1 = Online NULL
Secondary Recovery Health	Indicates the recovery health of a secondary replica, one of: 0 = In progress 1 = Online NULL
Synchronization Health	One of: 0 = Not healthy 1 = Partially healthy 2 = Healthy This metric summarizes the synchronization status of all replicas in the availability group: • Healthy if all replicas are fully synchronized. • Partially healthy if only some of the replicas are fully synchronized. • Not healthy if no replica is fully synchronized.
Failure Condition Level	0 - No automatic failover or restart; 1 - Failover or restart on server down; 2 - Failover or restart on server unresponsive; 3 - Failover or restart on critical server errors; 4 - Failover or restart on moderate server errors; 5 - Failover or restart on any qualified failure conditions.
Health Check Timeout	Availability Group health check timeout in milliseconds.
Automated Backup Preference	At an availability group level, specify whether backups should or should not run on the primary replica. The possible preferences for where backups should run are as follows: 0 - PRIMARY - Only on the primary replica - Backups should always occur on the primary replica. 1 - SECONDARY_ONLY - Performing backups on a secondary replica is preferable. 2 - SECONDARY - Performing backups on a secondary replica preferable, but performing backups on the primary replica is acceptable if no secondary replica is available for backup operations. This is the default behavior. 3 - NONE - No preference about whether backups are performed on the primary replica or on a secondary replica.

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.1.0 - User Guide

Agent Alert List

Agent Job List

Always On

Availability Groups