Foglight for SQL Server (Cartridge) 5.9.7.21


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.

Backup Locations

The collection shows drives or shares for backup locations.

Type

SQL Server.

Collection Sampling Intervals


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

Collection Metrics


Display Name	Description
Member Name	The total free space of the backup media.
Error Message	It indicates that there has been an error, which trying to reach media for inspection.
Media Used Space	The total used space on the media.
Media Free Percentage	The percentage of free space out of the total size of the media.
Media Used Percentage	The percentage of the used space our of the total size of the media.

Blocking History

This collection retrieves the hierarchical tree of all sessions involved in the blocking process. The hierarchical tree is based on snapshots taken at a predefined interval.

Type

SQL Server.

Collection Sampling Intervals


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

The total number of all blocked sessions.

Blocked by

The session that is currently blocking the selected session.

Blocked Time

Total wait time spent by all blocked sessions.

Command

The current or previous command executed.

CPU

The total amount of CPU consumed so far by the session. This metric can be useful when deciding which sessions to kill.

Database

The name of the database.

Host Name

The name of the client computer.

Lock Type

The type of the resource that is currently locked (Database, Table, Page, Row, Extent, and so on).

Locking

The unique session number for the session that either owns or requests the lock.

The time that the session was created.

Mode

The kind of lock being applied to the resource (Shared, Exclusive, Update, IntentShared, IntenExclusive and so on).

OS User

Windows user name for a session that uses Windows Authentication.

Physical IO

The total amount of I/O operations carried out so far by the session. This metric can be useful when deciding which sessions to kill.

Program

The name of the application that the user is currently running (for example, Microsoft Access).

Request Status

•

The status of the lock; can have one of the following values:

•

WAIT = Wait for another resource.

•

CNVT = Converted to another resource.

•

GRANT = the lock has granted.

Resource

The resource that is in conflict. This metric often identifies a database and table.

The data in the Resource column is reported directly from SQL Server and, for performance reasons, is not resolved to actual resource names during normal data collection.

SQL Text

Displays the SQL text of the session that is blocked and/or blocking.

SQL User

The SQL Server user login name for this session.

Status

The status of the session (Blocked, Blocking or both). For sessions at the head of the blocking chain (those that are not blocked), this metric also indicates if the session is Runnable or Sleeping.

Type

The type of the lock request that is waiting (for example: Database, Table, Page, Row, Key, and Extent).

Wait Time

Indicates how long this session has been waiting for the lock (measured in seconds). This shows 0 if the session is not waiting.

Blocking List

Purpose

This collection provides a display of a hierarchical list of sessions, which sorts the blocked and blocking sessions in a logical order.

Type

SQL Server.

Collection Sampling Intervals

This collection is an on-demand collection, which has no pre-defined sampling intervals.

Collection Metrics


Display Name	Description
Blocked By SPID	Indicates which SPID (if any) holds locks on a resource on which this session is waiting.
Command	The current or previous command executed. This information can be useful when deciding which sessions to kill.
CPU	The total amount of CPU consumed by the session so far. This information can be useful when deciding which sessions to kill.
Database	The name of the database.
Host Name	The name of the Client computer.
OS User	Windows user name for a session that uses Windows Authentication.
Physical I/O	The total amount of I/O consumed by the session so far. This information can be useful when deciding which sessions to kill.
Program	The application program that the user is using (for example, Microsoft Access).
Resource	The resource that is in conflict. This value often identifies a database and table. The Resource data is reported directly from SQL Server.
SPID	The session unique identifier (Session Process ID).
SQL Text	Displays the SQL belonging to the session that is blocked and/or blocking.
SQL User	The SQL Server user login name for this session.
Status	The status of the session (Blocked, Blocking or both). For sessions at the head of the blocking chain (those that are not blocked), this also indicates if the session is Runnable or Sleeping.
Type	The type of the lock request that is waiting (Database, Table, Page, Row, Key, Extent and so on).
Wait Time	Indicates how long this session has been waiting for the lock (measured in seconds). If the value displayed is 0, the session is not waiting.

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

Availability Groups

Backup Locations

Blocking History

Blocking List