Foglight for SQL Server (Cartridge) 7.1.0


Display Name	Description
Reporting Services Service Database Name	The name of the metadata database.
Total Reports Failed	Count of executions that were failed.
Total Reports Success	Count of executions that were success.

Resource Pool

The collection shows the usage of each resource pool.

Type

SQL Server.

Collection Sampling Intervals


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

Collection Metrics


Display Name	Description
Pool Name	Resource Pool name.
Used Memory	The amount of memory used by the resource pool.
Max Memory	The maximum amount of memory the resource pool can have. If significantly higher than target, it might indicate memory pressure.
Target Memory	The target amount of memory the resource pool is trying to gain. In case the value is significantly lower than maximum, it might indicate memory pressure.
Used Percentage	Percentage of memory used out of the overall memory allocated for the resource pool.
Out of Memory Count	The number of failed memory allocations.
Min Memory Percent	Minimum memory percentage consumed by the resource pool.
Max Memory Percent	Maximum memory percentage allowed by the resource pool.
Is Enabled	0 - The resource governor is disabled; 1 - the resource governor is enabled.

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.

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

Reporting Services

Resource Pool

Session Data

Session Trace