Chat now with support
Chat with Support

Foglight for Azure SQL Database (Cartridge) 5.9.7.20 - User Guide

Installing and Configuring Agents Using Foglight for Azure SQL Database Administering Foglight for Azure SQL Database Reporting Reference
Overview of Collections SQL Performance Investigator Metrics
Active Connections Active Time Active Time per Execution Active Time Rate Always On Average CPU Percent Average DTU Percent Average Memory Usage Percent Average SQL Response Time Average XTP Storage Percent Average Data IO Percent Average Log Write Percent Backup Recovery Blocked Sessions Connections CPU Limit CLR Wait CLR Wait per Execution CLR Wait Rate CPU Time CPU Time per Execution CPU Time Rate CPU Wait CPU Wait per Execution CPU Wait Rate Cursor Synchronization Database Replication Deferred Task Worker Distributed Transaction DTU Limit Elapsed Time Executions External Procedure Full Text Search Governor Wait Governor Wait per Execution Governor Wait Rate Granted Memory Hosted Component Inactive User Connections I/O Bulk Load I/O Completion I/O Data Page I/O Wait I/O Wait per Execution I/O Wait Rate Idle Time Internal Cache Latch Latch Buffer Latch Savepoint Latch Wait Latch Wait per Execution Latch Wait Rate Lead Blockers Lock Bulk Update Lock Exclusive Lock Intent Lock Schema Lock Shared Lock Update Lock Wait Lock Wait Rate Lock Wait per Execution Log Buffer Log Other Log Synchronization Log Wait Log Wait per Execution Log Wait Rate Log Write Logical Reads Logical Reads per Execution Max Degree of parallelism Max DTU Percent Max Session Percent Max Workers Percent Memory Wait Memory Wait per Execution Memory Wait Rate Network HTTP Network I/O Network IPC Network Mirror Network Wait Network Wait per Execution Network Wait Rate OLEDB Provider Full Text Other Miscellaneous Other Wait Other Wait per Execution Other Wait Rate Parallelism Wait Percent of Total Plan Recompilations Physical Reads Physical reads per Execution Preemptive Wait Preemptive wait per Execution Preemptive Wait Rate Remote Provider Wait Remote Provider wait per Execution Remote Provider Wait Rate Row count Service Broker Synchronous Task Wait Time Percent Writes Writes per Execution XTP Log write Wait XTP Miscellaneous Wait XTP Procedure Wait XTP Transaction Wait XTP Wait XTP Wait per Execution XTP Wait Rate
Glossary

Version Info

General Data about the database.

Azure SQL

Realtime Collection

3600

Online

3600

Offline

86400

Service Tier

The service tier for the database or data warehouse.

Service Tier Type

Purchase model. Can be DTU-based or vCore-based.

Pricing Tier

The pricing tier of the database.

Elastic Pool Name

The name of the elastic pool that the database belongs to.

Product Version

Version of the Azure SQL Database.

Product Level

Level of the version of the Azure SQL Database.

Collation

Name of the default collation for the server.

Version

Azure SQL DB version.

Resource Stat

Collection of average CPU, I/O, and memory consumption for an Azure SQL Database.

Azure SQL

Realtime Collection

30

Online

60

Offline

300

Sample Time

UTC time indicates the end of the reporting interval.

Avg CPU (%)

Average compute utilization in percentage of the limit of the service tier.

Avg Data IO (%)

Average data I/O utilization in percentage of the limit of the service tier.

Avg Log Write (%)

Average write I/O throughput utilization as percentage of the limit of the service tier.

Avg Memory Usage (%)

Average memory utilization in percentage of the limit of the service tier.

This includes memory used for storage of In-Memory OLTP objects.

Avg DTU (%)

Average DTU consumption in terms of a percentage of the maximum allowed DTU limit in the performance level for the user database.

Max DTU (%)

Maximum DTU consumption in terms of a percentage of the maximum allowed DTU limit in the performance level for the user database.

Max Workers (%)

Maximum concurrent workers (requests) in percentage of the limit of the database's service tier.

Max Session (%)

Maximum concurrent sessions in percentage of the limit of the database's service tier.

XTP Storage Utilization (%)

Storage utilization for In-Memory OLTP in percentage of the limit of the service tier. This includes memory used for storage of the following In-Memory OLTP objects: memory-optimized tables, indexes, and table variables. It also includes memory used for processing ALTER TABLE operations. 0 if In-Memory OLTP is not used.

Samples

Number of samples.

DTU Limit

Current max database DTU setting for this database during this interval. NULL if database using the vCore-based model.

CPU Limit

Number of vCores for this database during this interval. NULL if database using the DTU-based model.

Wait Statistics

Collects Database wait events grouped into resource categories.

Azure SQL

Realtime Collection

30

Online

60

Offline

300

Wait Type

Name of the wait type.

Wait Time

Total wait time for this wait type in milliseconds.

Database Connections Summary

Collects and gather aggregated information about recent state of sessions connected to the Azure SQL DB.

Azure SQL

Realtime Collection

30

Online

60

Offline

300

Total Connections

This shows the total number of Azure SQL DB sessions. It includes user and system sessions.

Blocked Sessions

The total number of blocked sessions.

User Connections

This shows the number of Azure SQL DB user (non-system) sessions.

System Connections

The number of Azure SQL DB system sessions.

User Active Connections

The number of non-system sessions that are actively processing in Azure SQL DB or that are waiting on locks.

client_hosts

Number of total client machines.

All Active Sessions

The number of all Azure SQL DB active connections.

Lead Blockers

The total number of lead blocker sessions.

User Inactive Sessions

The number of non-system sessions that are not actively processing in Azure SQL DB.

Foreground Sessions

The number of foreground sessions.

Background Sessions

The number of background sessions.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating