Foglight for SQL Server (Cartridge) 7.1.0


Display Name	Description
Deadlocks	The total number of deadlocks for the lock type. A Deadlock occurs when multiple SQL Server sessions request conflicting locks in such a way that two locks are blocked by one another.
Lock Requests	The summary of all lock requests, both for new locks and lock conversions.
Lock Timeouts	The number of lock requests per second that timed out, including requests for NOWAIT locks.
Lock Type	The name of the lock type.
Total Wait Time (seconds)	The total lock wait time for the lock type.
Total Waits	The total number of wait events for the selected lock type.

Locks List

This collection provides a list of locks used within a SQL Server instance, grouped by the lock type, mode, and status.

Type

SQL Server.

Collection Sampling Intervals


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

The server process ID of the current user process.

The time the session was created.

SQL Server Login name.

Database

The database that is being used by the current process.

Index Name

The index that is being used by the current process (if any).

Object Name

The name of the currently locked object.

Count

The number of locks that share the same object and type.

Lock Type

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

Mode

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

Status

The status of the lock can be one of the following:

•

WAIT = wait for another resource

•

CNVT = converted to another resource

•

GRANT = the lock has granted

Log Shipping

This collection specifies the Log shipping tree and the primary and secondary servers' file location and operations.

Type

SQL Server.

Collection Sampling Intervals


Frequency Mode	Collection Interval (In Seconds)
Real-time	20

The SQL process ID of the process that ran the query.

Rowset Key

The row identifier.

Owner

The current primary server.

Server Name

The name of the server (primary server for the parent node, and secondary server for all subsequent child nodes).

Database Name

Refers to either of the following databases:

•

For the parent node, this is the database that is backed up on the source server.

•

For each child node(s), this is the destination database on the secondary server.

Flag Error

An indicator of an error that occurred.

Threshold

The maximum allowed time (in minutes) before a Log Shipping alert occurs.

This parameter can refer to either of the following values:

•

For each parent node, this is the maximum allowed time since the last transaction log backup was made on the source server.

•

For each child node, this is the maximum allowed time between the last backup on the source server and the last restore on the secondary server.

Threshold Alert

The alert displayed in the Error Log drilldown if the threshold is exceeded.

Threshold Alert Enabled

The alert displays only if it is enabled.

Last Change

This parameter can refer to either of the following values:

•

For the parent node, this is the last time that the database was backed up.

•

For the child node(s), this is the last time a file was copied or restored. The Activity Type field displays this information.

Last Change Type

The type of the activity that resulted in the log shipping’s most recent change of state (Backup, Copy or Restore).

Last Backup Filename

The name of the file that was most recently backed up.

Last Backup Last Updated

The time at which the most recent backup operation was carried out.

Outage

During an outage, no alerts will occur when thresholds are exceeded (for both the parent and child nodes).

If this field is blank, no outage will take place.

Backup In Sync

Indicates either of the following backup statuses:

•

The backup is in sync mode.

•

The backup is out of sync and needs to be synchronized.

Backup Delta

The last time a log transaction backup occurred in the primary server.

Last Copied Filename

The last backup file that was copied to the secondary server.

Last Copied Last Updated

The time when the backup file was most recently copied from the primary to the secondary server.

Last Loaded Filename

The name of the backup file that was most recently restored to the secondary server.

Last Loaded Last Updated

The time when the backup file was most recently restored to the secondary server.

Copy Delta

The date when the transaction log backup file was most recently copied to the secondary server.

Copy Enabled

Indicates whether copying is enabled.

Load Enabled

Indicates whether loading is enabled.

Load in Sync

The load synchronization can have either of the following statuses:

•

The load is in sync mode.

•

The load is out of sync and needs to be synchronized.

Load Delta

The date of the last restored transaction log load file to the secondary server.

Primary Server Time

The current timestamp at the primary server.

Secondary Server Time

The current timestamp at the secondary server.

Monitor Server Time

The current timestamp at the monitored server.

Log Shipping Error

The collection shows Log Shipping Errors.

Type

SQL Server.

Collection Sampling Intervals


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

Collection Metrics


Display Name	Description
Session ID	The session ID for the backup/copy/restore/job.
Sequence Number	An incremental number indicating the correct order of information for errors that span multiple records.
Log Time	The date and time at which the record was created.
Server Name	The name of the server.
DB Name	The name of the database.
Agent Type	The type of log shipping job. 0 = Backup. 1 = Copy. 2 = Restore.
Agent Type Description	The description of the Agent Type.
Message	Message text.
Source	The source of the Error Message.
Status	If no Error for last hour - OK. If an error found on the last 15 minutes - ERROR. If there is an error between last hour and last 15 minutes nothing would be raised so the last error status should remain.

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

Lock Statistics

Locks List

Log Shipping

Log Shipping Error