Foglight for SQL Server (Cartridge) 6.3.0


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.