Foglight for SQL Server (Cartridge) 5.9.3.10


Display Name	Description
Distribution / Merge Agent	Name of the Distribution or Merge Agent for the subscription.
Latency	Highest latency, in seconds, for data changes propagated by the Log Reader or Distribution Agents for a transactional publication.
Log Reader Agent	Name of the Log Reader agent, if applicable.
Publication DB	The name of the database, which contains the publication that is replicated to the selected subscription
Publication Name	The name of the publication replicated to the selected subscription.
Publication Type	The type of publication replicated to the selected subscription; for example, Snapshot, Transactional, and Merge.
Publishing Server Name	The name of the SQL Server instance that hosts the selected publication database, whose data is replicated to the selected subscription.
Snapshot Agent	Name of the Snapshot Agent job for the publication.
Status	Highest (worst) severity status of the agents associated with the replication. For example, Started, Succeeded, In progress, Idle, Retrying, and Failed.
Subscribing Server	The name of the SQL Server instance that hosts the database where the selected Subscription resides.
Subscription DB	The name of the SQL Server instance that hosts the database where the selected Subscription resides.
Subscription Type	The selected subscription's type; for example, Push, Pull, Anonymous.

Session Data

This collection provides detailed data of the selected SQL Server session.

Type

SQL Server.

Collection Sampling Intervals

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

Indicates whether the process is active.

Blocked By

Which SPID (if any) holds locks that this session is waiting on (Blocked By).

CPU Usage

The Total CPU time that this session has used since connecting to the SQL Server.

Cache Hit Ratio

The percentage, for this session, of buffer cache hit ratio, that is: file read operations that were satisfied by the file system cache without requiring any physical I/O. The value of this metric should be as high as possible.

Context Info

Provides context information for the current session.

Current Wait Time

The amount of time this session has been waiting. This shows 0 if the session is not currently waiting.

DB User

The SQL Server login name for this session.

Database

The name of the database where the session is running.

Error Number

Indicates if the most recent statement completed by this session returned an error number; corresponds to the @@Error global variable for this session.

Can have two states:

•

Zero value - no error was returned

•

Positive value - an error was returned; the corresponding error text will be shown.

Host Name

The name of the Client host that is running the session.

Last Batch Time

The time the last batch started execution (Last Batch Time).

Last Command

The current or previous command executed.

Lock Timeout

The amount of time that this session waits for lock requests to be satisfied. Corresponds to the @@Lock_Timeout global variable for this session.

Logical Reads

Indicates the number of logical reads per second currently being performed by this session.

Logical reads are database page I/O requests that were satisfied from the Buffer Cache and therefore did not have to perform disk reads.

The time the session was created.

Memory

Memory is the number of pages in the procedure cache that are currently allocated to this process. A negative number indicates that the process is freeing memory allocated by another process.

Most Recent SQL

Shows the batch of SQL statements last executed or currently executing by the selected session.

Physical Reads

Shows the number of physical reads per second currently being performed by this session.

Physical Writes

Shows the number of physical writes per second currently being performed by this session.

Program

The Program that the user is running in order to access SQL Server.

SPID

The SQL process number.

Status

The session Status (runnable, sleeping, blocked and so on).

System Process

A flag indicating the session type:

•

Y= a system session

•

N = a non-system session.

Total I/O

The total amount of I/O operations (including background I/O) performed by the session from the time it connected to the SQL Server.

Transaction Count

The number of open transactions; corresponds to the session's @@TRANCOUNT value.

Session Trace

This collection traces over events that occurred in the currently monitored SQL Server instance.

Type

System.

Collection Sampling Intervals

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

Collection Metrics


Display Name	Description
SPID	The session unique identifier (Session Process ID). The unique number that SQL Server has assigned to identify the selected session.
Start Time	The time when the class event started.
End Time	The time when the class event ended.
Event Class	The type of class that was traced.
Duration	The duration, in milliseconds, of the event class.
Text Data	The SQL text that was captured as a result of the trace event.
Reads	The number of logical disk reads carried out by the server on behalf of the event.
Writes	The number of physical disk writes carried out by the server on behalf of the event.
CPU	The amount of CPU time (in milliseconds) used by the event.
Database ID	ID of the current database.
Object Name	System-assigned ID of the object.
Index ID	ID for the index on the object affected by the event.

SQL Server Connections Summary

This collection provides general information about all of the connections in SQL Server.

Type

SQL Server.

Collection Sampling Intervals


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

Collection Metrics


Display Name	Description
Active Connections Percent	The percentage of active connections as part of the user sessions.
All Active Connections	The number of all SQL active connections.
Background Sessions	The total number of background sessions.
Blocked Connections	The total number of blocked sessions.
Blockers Connections	The total number of blocking sessions.
Connections Running DBCC	The total number of sessions running a DBCC command.
Foreground Sessions	The total number of foreground sessions.
Internal Connections	The number of internal connections of the SQL Server instance.
Machine Connections	The number of Client computers that currently have at least one SQL Server session.
Max Block Time	The maximum duration (in seconds) a current process was blocked.
Max Connections Allowed	The maximum number of user connections that SQL server allows.
Max Threads Allowed	The maximum number of threads that SQL server is configured to handle.
SQL Active Threads	The total number of the instance’s currently active threads.
SQL Executions	The total number of time that the selected statement executed during the specified time range. NOTE: This data is available only if StealthCollect is installed and configured
System Connections	The number of SQL Server system sessions.
Total Connections	The total number of SQL Server sessions, including user and system sessions.
User Active Connections	The number of non-system sessions that are actively processing in SQL Server or that are waiting on locks.
User Connections	The number of SQL Server user (non-system) sessions, excluding SQL Server Agent sessions.
User Inactive Connections	The number of non-system sessions that are not actively processing in SQL Server.
Worker Threads Used Percent	The percentage of active threads out of the maximum number of threads that SQL server is configured to handle.

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

Replication Subscriptions

Session Data

Session Trace

SQL Server Connections Summary