Chat now with support
Chat with Support

Foglight for Azure SQL Database (Cartridge) 7.2.1 - 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

Database Replication

Purpose

Collects Database replication status.

Collection Type

Azure SQL

Collection Sampling Settings
 
 
Frequency Mode
Collection Interval (Seconds)

Realtime Collection

60

Online

300

Offline

300

Metric Descriptions
 
 
Metric
Description

Partner Server

Name of the SQL Database server containing the linked database.

Partner Database

Name of the linked database on the linked SQL Database server.

Last Replication

The timestamp of the last transaction's acknowledgement by the secondary based on the primary database clock. This value is available on the primary database only.

Replication Lag (Sec)

Time difference in seconds between the last_replication value and the timestamp of that transaction's commit on the primary based on the primary database clock. This value is available on the primary database only.

Replication State

The state of geo-replication for this database, one of:

•
SEEDING: The geo-replication target is being seeded but the two databases are not yet synchronized. Until seeding completes, you cannot connect to the secondary database. Removing secondary database from the primary will cancel the seeding operation.
•
CATCH_UP: The secondary database is in a transactionally consistent state and is being constantly synchronized with the primary database.
•
PENDING: This is not an active continuous-copy relationship. This state usually indicates that the bandwidth available for the interlink is insufficient for the level of transaction activity on the primary database. However, the continuous-copy relationship is still intact.

Geo-replication Role

Geo-replication role, one of:

•
PRIMARY: The database_id refers to the primary database in the geo-replication partnership.
•
SECONDARY: The database_id refers to the primary database in the geo-replication partnership.

Last Commit

The time of last transaction committed to the database. If retrieved on the primary database, it indicates the last commit time on the primary database. If retrieved on the secondary database, it indicates the last commit time on the secondary database. If retrieved on the secondary database when the primary of the replication link is down, it indicates until what point the secondary has caught up.

Database Storage

Purpose

Collects Database storage information.

Collection Type

Azure SQL

Collection Sampling Settings
 
 
Frequency Mode
Collection Interval (Seconds)

Realtime Collection

60

Online

300

Offline

3600

Metric Descriptions
 
 
Metric
Description

Allocated

The amount of formatted file space made available for storing database data.

The amount of space allocated grows automatically, but never decreases after deletes. This behavior ensures that future inserts are faster since space does not need to be reformatted.

Unused

The difference between the amount of data space allocated and data space used.This quantity represents the maximum amount of free space that can be reclaimed by shrinking database data files.

Used

The amount of space used to store database data. Generally, space used increases on inserts. In some cases, the space used does not change on inserts or deletes depending on the amount and pattern of data involved in the operation and any fragmentation. For example, inserting one row does not necessarily increase the space used.

Used Utilization

Amount of used size as a percentage of maximum amount of space set to the database.

Max Storage Size

The maximum amount of space that can be used for storing database data.

Database Recommendations

Purpose

Collects counter of all tuning recommendations of Azure SQL DB

Collection Sampling Settings
 
 
Frequency Mode
Collection Interval (Seconds)

Realtime Collection

60

Online

900

Offline

3600

Metric Descriptions
 
Metric
Description

Name

Unique name of recommendation.

Query ID

The query_id of the regressed query.

Type

The name of the automatic tuning option that produced the recommendation. For example, FORCE_LAST_GOOD_PLAN

Reason

Reason why this recommendation was provided.

Current State Reason

Constant that describes why the recommendation is in the current state.

Impact

Estimated value/impact for this recommendation on the 0-100 scale (the larger the better).

Script

Transact-SQL script that should be executed to force the recommended plan.

Reason Description

Describes why the recommendation is in the current state.

Regressed Plan ID

The plan_id of the regressed plan.

Recommended Plan ID

The plan_id of the plan that should be forced.

Regressed Plan Error Count

Number of errors of the query with regressed plan before the regression is detected.

Recommended Plan Error Count

Number of errors of the query with the plan that should be forced before the regression is detected.

Regressed Plan Execution Count

Number of executions of the query with regressed plan before the regression is detected.

Regressed Plan CPU Time Average

Average CPU time consumed by the regressed query before the regression is detected.

Recommended Plan Execution Count

Number of executions of the query with the plan that should be forced before the regression is detected.

Recommended Plan CPU Time Average

Average CPU time consumed by the query executed with the plan that should be forced (calculated before the regression is detected).

Valid Since

The first time this recommendation was generated.

Estimated Gain

Total CPU Time gain if we will apply the recommendation.

Error Prone

Yes, if regressedPlanErrorCount > recommendedPlanErrorCount.

SQL Performance Investigator Metrics

Active Connections

Number of all active connections, which were active during the current interval.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating