Foglight for Azure SQL Database collects raw data for a set of collection types. This data is used by the Rules to trigger alarms and is used to populate dashboards. The collections data tables are not viewable from Foglight for Azure SQL Database, but the data is implemented in the various drilldowns of Foglight for Azure SQL Database.
Retrieves database usability based on response time and database availability.
Average duration of the SQL statements that executed during the specified time range. | |
The amount of time Azure SQL DB was running since it was created. |
Collects query store information.
When the desired_state_desc is READ_WRITE and the actual_state_desc is READ_ONLY, readonly_reason returns a bit map to indicate why the Query Store is in readonly mode. 1 - database is in read-only mode 2 - database is in single-user mode 4 - database is in emergency mode 8 - database is secondary replica (applies to Always On and Azure SQL Database geo-replication). This value can be effectively observed only on readable secondary replicas | |||||
The period for regular flushing of Query Store data to disk in minutes. Default value is 15 minutes. Change by using the ALTER DATABASE <database> SET QUERY_STORE (DATA_FLUSH_INTERVAL_SECONDS = <interval>) statement. | |||||
Number of days that the information for a query is kept in the Query Store. Default value is 30. Set to 0 to disable the retention policy. For SQL Database Basic edition, default is 7 days. Change by using the ALTER DATABASE <database> SET QUERY_STORE ( CLEANUP_POLICY = ( STALE_QUERY_THRESHOLD_DAYS = <value> ) ) statement. | |||||
Actual size-based cleanup mode of Query Store. can be:
| |||||
Indicates whether Query Store performs capture of wait statistics. | |||||
Percentage of current storage size out of the Max Storage Size. |
Collects query store top SQLs.
© ALL RIGHTS RESERVED. 利用規約 プライバシー Cookie Preference Center