Foglight for SQL Server (Cartridge) 7.3.0


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.

SQL PI Instance Statistics

SQL PI Instance Statistics.

Type

SQL Server.

Collection Sampling Intervals


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

Collection Metrics


Display Name	Description
CPU Usage	CPU consumption of all the requests running on the monitored instance. Value can be larger than clock time if there is more than one CPU running.
CPU Usage Rate	Rate of CPU consumption of all the requests running on the monitored instance.
Num Executions	The number of statements executed during the current interval.
Num Executions Rate	Rate of statements executed during the current interval.
Total Logical Reads	The total number of logical reads operations performed by all requests running on the instance.
Total Logical Reads Rate	The average number of logical reads operations per second performed by all requests running in the instance.
Total Writes	The total number of logical writes operations performed by all requests running on the instance.
Total Writes Rate	The average number of logical writes operations per second performed by all requests running in the instance.
Total Physical Reads	The total number of physical reads operations performed by all requests running in the instance.
Total Physical Rate	The average number of physical reads operations per second performed by all requests running in the instance.
Row Count	The number of rows that have been returned to the client.
Tempdb I/O	Amount of time spent waiting for IO against Tempdb.
Tempdb GAM Wait	Amount of time spent waiting for a Global Allocation Map (GAM) page of Tempdb. GAM page tracks which extents have been allocated. The high amount of wait for an allocation page may indicate that the Tempdb is not configured according to best practice recommendations.
Tempdb SGAM Wait	Amount of time spent waiting for a Shared Global Allocation Map (SGAM) page of Tempdb. SGAM tracks which extents are being used as mixed (shared) extents. The high amount of wait for an allocation page may indicate that the Tempdb is not configured according to best practice recommendations.
Tempdb PFS Wait	Amount of time spent waiting for a Free Space (PFS) page of Tempdb. PFS tracks the allocation status of each page and approximately how much free space it has left. The high amount of wait for an allocation page may indicate that the Tempdb is not configured according to best practice recommendations.
Plan Recompilations	The number of times the plan of the statement was recompiled. For batch - this metric indicates the number of times at least one statement in the batch was recompiled.
Elapsed Time	Amount of time it took for the execution to end. This includes both active and idle time.
Degree of Parallelism	The maximum number of SQL Server threads assigned to the activity.
Granted Query Memory	The maximum amount of memory (KB) allocated to the execution of an activity.

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

Resource Pool

Session Data

Session Trace

SQL PI Instance Statistics